Skip to main content

AnyDB Date Cell

Date Cell Type

Date cells are designed to store date values. AnyDB stores date values as a timestamp that is the number of seconds since the Unix epoch (January 1, 1970). This allows for easy manipulation and comparison of date values.

Date Cell Options

Additional Options

Date cells have the following additional options:

Date Cell Options

  • Format: Set the format in which the date will be displayed. You can choose from various formats, such as YYYY-MM-DD, MM/DD/YYYY, etc. The default format is YYYY-MM-DD.
  • Absolute: Enable or disable the use of absolute dates. When enabled, the date will not be converted to local time when being displayed. This is useful for storing dates that should not be affected by time zone changes.
tip

Note: When you set a date value, that date is converted to a UTC timezone based date. When being displayed, it is converted to the local timezone of the browser for display.