How to Consolidate date formats?

[jgarciaf106]

Hi,

I have a few tables that contains the date field,

I want to consolidate all date fields into one to create a master calendar, I was able to achieved that but the problem I am facing is the date field from the different tables comes in diferent date formats, how can I consolidate all date formats into one single format?

Thanks in advance.

[MK_QSL · Accepted solution]

You can use below functions to make different date formats to common format.

DATE

DATE#

ALT

Check this document..

QlikView Date fields

[zebhashmi]

Alt(date1(),Date2(),Date3(),)