Convert String to Date & Time

[manojkulkarni]

Hi Friends,

How to convert the below string into Date&Time Format ?  If data coming in different formats then how it should be handled ?

"Thu  3/9/2017 6:10 PM"

[PrashantSangle]

Hi,

actually I never try this but i try

date(today(),'www DD/MM/YYYY hh:mm TT')  which gives me 'Tue 14/03/2017 12:00 PM'

So I thought same format should work for date#(), But i checked it is not working.

might be we need to do some setting in ester egg.

Regards,

Prashant

[sunny_talwar]

Make sense.... Ya, I had trouble with weekday in Date# function.

[manojkulkarni]

Thanks Sunny ,  It worked