sullisnyc44
asked on
calculated date column returns the wrong day
=TEXT([Start Time],"ddd, dd MMMM")
is off by one day. why? it's an all day event in a standard calendar.
is off by one day. why? it's an all day event in a standard calendar.
Hi,
Use excel functions, e.g. if you have the datetime column use the following code to return date as string
column name= 'Date of Birth'
calculated column formula = YEAR(DateOfBirth)&"-"&DAY( DateOfBirt h)&"-"&MON TH(DateOfB irth)
Use excel functions, e.g. if you have the datetime column use the following code to return date as string
column name= 'Date of Birth'
calculated column formula = YEAR(DateOfBirth)&"-"&DAY(
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
this works
I've tried the following:
24 March 2012 Sat, 24 March
24/03/2012 00:00 Sat, 24 March
24/03/2012 Sat, 24 March
25 March 2012 Sun, 25 March
25/03/2012 00:00 Sun, 25 March
25/03/2012 Sun, 25 March
26 March 2012 Mon, 26 March
26/03/2012 00:00 Mon, 26 March
26/03/2012 Mon, 26 March