Timestamp format

[nareshthavidishetty]

Hi everyone,

      As I am stuck while converting a field into timestamp format. My sample Data looks like below  and I have attached the sample excel file.

1/17/2017   8:28:11AM

Expected output = 'DD-MM-YYYY hh:mm:ss'.

Thanks in advance.

[Anonymous]

=date(date#('1/17/2017   8:28:11AM','M/DD/YYYY   h:mm:sstt') , 'DD-MM-YYYY hh:mm:ss' )

[tresesco]

Try like:

=TimeStamp(Timestamp#('1/17/2017   8:28:11AM', 'MM/DD/YYYY   h:mm:ssTT'),'DD-MM-YYYY hh:mm:ss')

[nareshthavidishetty]

Hi,

     Ya its working fine if we use that in front end.

But the problem is if I load that Excel file and then use that in script its not working.

Could u please load the Excel file which I have attached and convert that field to Timestamp.

Thanks

[tresesco]

I don't find any excel attached.

[nareshthavidishetty]

Sorry for that.

Please find the attachment.

[tresesco]

Try:

TimeStamp(Timestamp#([Email Sent Date], 'MM/DD/YYYY   h:mm:ssTT'),'DD-MM-YYYY hh:mm:ss') as NewDate

[Anonymous]

In addition,

you will get the same result with using Date function.

Date(Date#([Email Sent Date], 'MM/DD/YYYY   h:mm:ssTT'),'DD-MM-YYYY hh:mm:ss') as NewDate