unix

The unix operation converts a given date into a Unix timestamp — the number of seconds elapsed since January 1, 1970 (UTC).

How it works

  • If the input is a valid date, the operation returns the corresponding Unix timestamp.
  • If the input cannot be interpreted as a valid date, the operation returns the original value unchanged.

Examples

InputOutput
2024-12-251735084800
01/01/19700
2025-03-01 12:001740830400
invalid-dateinvalid-date (unchanged)

Usage in PalDock

Use unix when you need to:

  • Normalize date fields into numeric timestamps.
  • Pass dates to APIs that expect Unix time instead of formatted strings.
  • Compare dates numerically (e.g. before/after checks).

Best Practices

  • Always ensure the date is in a recognizable format (e.g. ISO 8601: YYYY-MM-DD or YYYY-MM-DD hh:mm:ss).
  • Remember that the Unix timestamp is calculated in UTC.
  • Use unix together with date formatting or modify-date operations when you need to shift or reformat dates.

Related articles

Modify Field > combine
Modify Field > urldecode
Modify Field > urlencode
Modify Field > load-from-lead
Modify Field > regex-replace
Modify Field > from-base64
Modify Field > to-base64
Modify Field > modify-date
Modify Field > format-date
Modify Field > do-not-send

Insights that
helps you grow