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
stringThe 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
stringThe 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.
AsColumn
nameName 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.