Link to home
Start Free TrialLog in
Avatar of sullisnyc44
sullisnyc44Flag for United States of America

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.
Avatar of wshark83
wshark83
Flag of United Kingdom of Great Britain and Northern Ireland image

works fine for me...is the [Start Time] formatted as date?

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
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(DateOfBirth)&"-"&MONTH(DateOfBirth)
ASKER CERTIFIED SOLUTION
Avatar of sullisnyc44
sullisnyc44
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of sullisnyc44

ASKER

this works