topic Re: Connection between two tables with different date format in QlikView

Connection between two tables with different date format

Peony — Sat, 16 Nov 2024 20:09:52 GMT

Hi All

Please, could anyone gove an advise to finde the silution for the task below.

I have a two tables with different date type MM/DD/YYYY and MMMYYYY.
I need to create common table with correspondence between these tables data.
I suppose I need to convert TargetDate to MM/DD/YYYY . But I dont uderstent how to do it .

Re: Connection between two tables with different date format

Vegar — Fri, 30 Aug 2019 21:51:12 GMT

You can convert TargetDate to your desired format like this.

Date(date#(TargetDate,'MMMYYYY'),'MM/DD/YYYY')

Re: Connection between two tables with different date format

Peony — Sat, 31 Aug 2019 09:51:56 GMT

Thank you!