Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to get common month and year

i have Startdate and Enddate in a table....

my requirement is i need a single Date field  which is having both start and end date and also month field and year field

Output : Date  Month Year

How to do this?

2 Replies
sunny_talwar

You can use While Loop to create missing dates

Loops in the Script

or you can use interval match

IntervalMatch

rido1421
Creator III
Creator III

Hi Sanju

I believe you will need to use interval match, read up on the below.

IntervalMatch

Regards,