Convert String to Date

[anuradhaa]

I have below String and want to convet it to date

Dec 2, 2012

[Chanty4u]

Hi,

=num('Dec 2, 2012')

[Chanty4u]

or

=Num(Timestamp#(FieldName, 'YYYY-MM-DD '))

or

=Num(Timestamp#('2015-05-26 12:34:38', 'YYYY-MM-DD hh:mm:ss'))

[tamilarasu]

Try,

Date(Date#('Dec 2, 2012', 'MMM DD, YYYY'))

[MK_QSL]

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'))

[ramasaisaksoft]

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

[Chanty4u]

hi,