Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

ag732312
New Contributor II

How to Consolidate date formats?

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.

1 Solution

Accepted Solutions

Re: How to Consolidate date formats?

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

DATE

DATE#

ALT

Check this document..

QlikView Date fields

2 Replies

Re: How to Consolidate date formats?

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

DATE

DATE#

ALT

Check this document..

QlikView Date fields

zebhashmi
Valued Contributor

Re: How to Consolidate date formats?

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

Community Browser