Date
Returns a current date as a value .
- Returned Output: Text
- Library: PQL \ Common \ Date-Time
- Version: 2020.10.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
Date()
Comments
- The function takes no inputs.
- This function is often used in conjunction with other date-time functions to perform operations when the date or time need to be determined at the time of execution.
Different Function types
- To create a date-time value using string representations of time see StringtoDateTime. To create a date time from specific year, month and day numbers use CreateDate
- To get the current date-time member, use the Semantic library function.
Examples
This example returns the current date and time "2019-Apr-08 14:35:00.2"
dateTime()