ConstDateTime / New Layer

Create a new column with a constant date/datetime value. Similar to pandas Timestamp or Python's datetime objects. Useful for adding reference dates, creating timestamp columns, or marking specific points in time across all rows.

Table
0
0
Table

Value

string

The date/datetime Value to fill the column with. Must match the specified Format. Examples:

  • 2024-01-31
  • 2024-01-31 15:30:00
  • 31/01/2024
  • Jan 31 2024

Format

string

The format pattern string for parsing the datetime Value. Uses strftime/strptime syntax similar to Python's datetime. Common patterns:

  • %Y-%m-%d (e.g., 2024-01-31)
  • %Y-%m-%d %H:%M:%S (e.g., 2024-01-31 15:30:00)
  • %d/%m/%Y (e.g., 31/01/2024)
  • %b %d %Y (e.g., Jan 31 2024)

Refer to strftime documentation for full specification.

Name for the new column. If not provided, the system generates a unique name. If AsColumn matches an existing column, the existing column is replaced. The name should follow valid column naming conventions.