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
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!
@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!