Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
ValeriaBonini
Partner - Creator
Partner - Creator

Modify a date

I have a date field with many dates (format DD/MM/YYYY), i would like to create a new column with these conditions:

 

if date is between 13/08/YYYY and 17/08/YYYY -> date become 15/09/YYYY

if date is between 13/12/YYYY and 17/12/YYYY -> date become 15/01/YYYY

 

 

how can I do this?

Labels (6)
11 Replies
vinieme12
Champion III
Champion III

@ValeriaBonini  have you tried the above? did it work? 

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
ValeriaBonini
Partner - Creator
Partner - Creator
Author

I tried, but it doesnt shows the right format

ValeriaBonini_0-1669634356334.png