Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community,
I have a small doubt about Date Format
I am having Field with name Start Date and it is in Date in format of '2011/01/15 00:00:00'
I want to convert this in to MM/DD/YYYY Format I have used Date(floor([Start Date])) and also
Date([Start Date],'MM/DD/YYYY') But it showing null value . It should be Like 01/15/2011
Please Help me with this Issue
Thank you,
Swarup
May be like this...
Date(Floor([Start Date]),'MM/DD/YYYY')
May be this:
Date(Floor(Date#(DateField, 'YYYY/MM/DD hh:mm:ss')), 'MM/DD/YYYY) as DateField
or
Date(Floor(Date#(Left(DateField, 10), 'YYYY/MM/DD')), 'MM/DD/YYYY) as DateField