Skip to Content

Can anyone tell me this timestamp formula

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


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • May 15 at 07:17 PM

    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

    Add comment
    10|10000 characters needed characters exceeded