Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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,