+ Start a Discussion
arjunkodidalasfdc1.3904276015566733E12arjunkodidalasfdc1.3904276015566733E12 

Date in Site.com Data Repeater

Hi,

I am tryting to display date in Site.com data repeater. In the edit data element i choosed a date field. In the preview its showing a day lesser than the current date. If the actual field date is 03/11/2014, it is displaying as 03/10/2014. If i use formatGMT it is displaying as Tue Mar 11 2014: xx:xx:xx PM.  I dont want day and time in the out put. So i formated date as below. But it is not working.

(ValueOfGmt(formatGMT({!Syndication_Date__c}))).format("MM/DD/YYYY")

I want date in the format of 03/11/2014. Can any one correct this.

Thanks.

ericmonteericmonte
I've been trying to figure this out myself, but here is a workaround you can do. Create a formula field to display the field into your suggested format the reference that field in your Site.com.

I wish there was an easier way to do this in Site.com :(
arjunkodidalasfdc1.3904276015566733E12arjunkodidalasfdc1.3904276015566733E12
Hi Eric,

The problem is not with the format., its with the date.
 If the date is 03/11/2014, it  is displaying as 03/10/2014.


ericmonteericmonte
I see your issue. So when the records date/time formate was entered it was entered in GMT, meanwhile based on your User's record you are set in sepcific timezone. Therefore it will display the local time zone based on the user profile. Does this make sense?


Here is an example, if a user creates a record and the last modified date of this record is set to followingUCT 3/11/2014 4:00 AM, and then a user whose local time zone is set on Eastern Time, the display of date time will be different based on the time zome. So the user will end up seeing 3/10/2014 xx:xx pm and etc...

Let me know if this make sense.