Help with timestamp field

[josemaria_cabre]

Hi,

I have a timestamp dimension in this format:

2021/02/07 11:04:23.918000000

How do I transform this string to date, with format DD-MM-YYYY hh:mm?

Thanks in advance for your help

[Taoufiq_Zarra · Accepted solution]

@josemaria_cabre  Maye be :

=timestamp(timestamp#(YOURFIELD,'YYYY/MM/DD hh:mm:ss.ffff'),'DD-MM-YYYY hh:mm')

Example:

for :

=timestamp(timestamp#('2021/02/07 11:04:23.918000000','YYYY/MM/DD hh:mm:ss.ffff'),'DD-MM-YYYY hh:mm')

the output: