QlikWorld 2020 Global Conference. Join us to discover how to get the most from your data. Act fast. Register now and save.

DateFormat

The format defined replaces the date format of the operating system (regional settings).

Syntax:  

DateFormat

Examples:  

Set DateFormat='M/D/YY'; //(US format)

Set DateFormat='DD/MM/YY'; //(UK date format)

Set DateFormat='YYYY-MM-DD'; //(ISO date format)

Did this information help you?

Thanks for letting us know. Is there anything you'd like to tell us about this topic?

Can you tell us why it did not help you and how we can improve it?