How to convert Wednesday, April 01, 2015 12:00:AM to timestamp as dd/mm/yy hh:mm:ss

[#1]

How Can convert  "Wednesday, April 01, 2015  12:00:AM" to timestamp as dd/mm/yy hh:mm:ss i.e. 01/04/2015 00:00:00

[PrashantSangle]

Hi,

Use timestamp(timestamp#(DateField,'WWWW, MMM DD, YYYY hh:mm tt'),'DD/MM/YY hh:mm:ss')

Regards

[engishfaque]

Dear Binod,

Please try this one,

Timestamp(FieldName,'DD/MM/YYYY hh:mm:ss TT') as DateTime

Might be possible, you're facing problem due to UTC time format. If yes, please let me know.

Kind regards,

Ishfaque Ahmed

[#4]

Tried both none worked

[jonathandienst]

You need to strip the weekday out. And you have two spaces between the year and the time:

Field MyTimeStamp = 'Wednesday, April 01, 2015  12:00:AM'

                     ^^^^^^^^^^               ^^

Date(Date#(Trim(Mid(MyTimeStamp, Index(MyTimeStamp, ',')+ 1, 100)), 'MMMM DD, YYYY  hh:mm:TT'), 'YYYY/MM/DD hh:mm') As FormattedDateTime

[fvelascog72]

Hi, Try:

Timestamp(MakeDate(SubField(DATE_FIELD,' ',4),ApplyMap('Months',SubField(DATE_FIELD,' ',2)),purgechar(SubField(DATE_FIELD,' ',3),','))&' '&Time(Time#(SubField(DATE_FIELD,'  ',2),'hh:mm:tt'),'hh:mm:ss'))

[MarcoWedel]

Hi,

some similar solution to Jonathan's:

=Timestamp(Timestamp#(Mid('Wednesday, April 01, 2015  12:00:AM',Index('Wednesday, April 01, 2015  12:00:AM',',')+2), 'MMMM DD, YYYY  hh:mm:TT'),'DD/MM/YY hh:mm:ss')

hope it's helpful as well.

regards

Marco