Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Roliba001
Contributor III
Contributor III

6 Months Range - Sep to Feb

Hi,

I need to creat two date ranges variables

vWinter - between March and August       (Example - March16 until August16)

vSummer - between September and February from next year  (Example - September16 until February17)


Anyone can help me to creat them?




2 Replies
Anil_Babu_Samineni

Can we know, How your data looks like. And What is the Maximum date records you have?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Colin-Albert

Effectively you are using a financial (fiscal) year that runs March - Feb or Sept - Aug.

This posts shows how you can implement this  Fiscal Year