
Contributor
2018-09-21
07:20 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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)
37,891 Views
2 Replies


Specialist III
2018-09-21
07:58 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Yes.
Date(DateFieldName + 90) will add 90 days to the date in DateFieldName

MVP
2018-09-22
03:13 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
37,771 Views
