What is the recommended format to store date fields?

Last updated 22, Mar 2024

Question

What is the recommended format for storing date fields?

Answer

The field needs to be NUMERIC and store UNIX Epochs in seconds. If range filtering using the date field is not required, and you'd like to tag records with a month/day in a tag field, you can use a string and index as TAG.

References

Learn more about tags and numeric indexes.