Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
akuligod
Contributor
Contributor

Add days to date

Can days be added to a date in qlikview in MM/DD/YYYY format?

Want to add 90 days to the date field..

ex: 09/01/2017 add 90 days 12/01/2017  (approx)

2 Replies
nagaiank
Specialist III
Specialist III

Yes.

Date(DateFieldName + 90) will add 90 days to the date in DateFieldName

rubenmarin

Hi, added to Nagaian answer, if the required date format is different to the date format used by the document, you can set a specific date format using the 2nd parameter of Date function:

Date(DateFieldName + 90, 'MM/DD/YYYY')


Default date format is defined (usually) at the beggining of script:

SET DateFormat='MM/DD/YYYY';

SET TimestampFormat='MM/DD/YYYY h:mm:ss[.fff]'; // For timestamp() functions