Millisecond part of the date

Ask for Help
1

2023-05-09T14:25:23.523Z

year(DATE), month(DATE), minute(DATE), seocnds(DATE)

Is there one to get the milliseconds ? the 523 part of the date ?

Also is there a post/doc listing all the functions available on the DATE component ?

2

image
image703×496 21.5 KB

I think this is the way. What are you going to do with that part?

I’m not aware of that, but others may be able to chime in.

3

Documentation isn’t great regarding all of the possible math column functions, and there are a handful that aren’t listed, but I’m pretty sure there isn’t anything available in the math column to get milliseconds.

It would be nice to have a complete list, and I wish the math column itself would get more love from Glide. It has so much potential and runs incredibly efficiently.

4

I am going to use the millisecond to append to the end of a unique incrementor to ensure/minimise duplicate IDs