Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have below String and want to convet it to date
Dec 2, 2012
Hi,
=num('Dec 2, 2012')
or
=Num(Timestamp#(FieldName, 'YYYY-MM-DD '))
or
=Num(Timestamp#('2015-05-26 12:34:38', 'YYYY-MM-DD hh:mm:ss'))
Try,
Date(Date#('Dec 2, 2012', 'MMM DD, YYYY'))
Back end in script..
Date(Date#('Dec 2, 2012','MMM D, YYYY')) as YourDateField
or
Date(Date#(YourDateField,'MMM D, YYYY')) as YourDateField
front end
=Date(Date#('Dec 2, 2012','MMM D, YYYY'))
orDate(Date#(YourDateField,'MMM D, YYYY'))
Hi Anu,
if this is a single value
=num(Dec 2, 2012)
else if it is field select the filed into list box and go to Number tab of a list box
hi,