DateToTimeStamp (PQL)

Converts date-time to Epoch time value.

  • Returned Output: Epoch Time
  • Library: PQL \ Common \ Date-Time
  • Version: 2020.12.000
  • Compatibility:
    • Can be combined with and other PQL function throughout the application.
    • It CANNOT be used with MDX or VBA functions. But it can be used on MDX-based content in other parts of the application.

Syntax

DateToTimeStamp( <Date-Time> )

* Click on the function's arguments above for more details on the input values.

Comments
  • The function converts any date time value into Epoch time - which is the number of milliseconds between the supplied date and "1970-01-01".
  • Epoch Time is often used in specialized date-time logic.
Different Function types

Examples

This example, using the current date, returns the something like '1599379000'

DateToTimestamp(Date())