Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Peony
Creator II
Creator II

Connection between two tables with different date format

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 .

Labels (2)
1 Solution

Accepted Solutions
Vegar
Partner
Partner

You can convert TargetDate to your desired format like this.

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

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

2 Replies
Vegar
Partner
Partner

You can convert TargetDate to your desired format like this.

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

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

Peony
Creator II
Creator II
Author

Thank you!