Skip to Content
0

Can anyone tell me this timestamp formula

May 15 at 06:11 PM

35

avatar image

Hello Friends,

I have a date in this format 20180515YYYYMMDD 100433. I want the output to be shown as

DD/MM/YYYY HH:MM:SS. Please help me in writing this formula in WEBI.


Thanks

Radhika


10 |10000 characters needed characters left characters exceeded

Tried with TODATE and FORMATDATE. But not working..Please help

0
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Jyothirmayee A May 15 at 07:17 PM
0

Hi,

FormatDate() should work. what is your formula says?.

=FormatDate([Date];”dd/MM/yyyy hh:mm:ss “)?.

Try both functions:

Formatdate(todate([Date];"yyyyMMdd") ;"dd/MM/yyyy hh:mm:ss")

Thanks,

Jothi

Share
10 |10000 characters needed characters left characters exceeded