How to get Date and Time in microseconds

[sahartz]

Hi,

I am trying to use the new "microseconds" format but all I am getting is only the microseconds and not the full date-time.

The formula I'm using -

The result is -

the result should be -

Would appreciate you inputs

Thanks,

Sahar

[alexnajm]

What is the goal of your output? It's hard to tell since we can't see the original Event Date values

Current state, it looks like you are trying to minus 2 milliseconds from 1900-01-01!

[sahartz]

@alexnajm 

The incoming data is in "Double" format -

And the result should be -

[tristank]

@alexnajm is correct. Your current formula is applying the datetimeadd function to a fixed date in 1900. If you are going to add ms to a date value and are expecting the output you have shown in the picture then you need to change the date you are adding to. This may require properly formatting a date field before using it in your formula.

If you are still struggling then please add some fake data that shows the expected output so we can play around.

Have a great week!