topic Re: Add days to date in QlikView

Add days to date

akuligod — Fri, 21 Sep 2018 23:20:19 GMT

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)

Re: Add days to date

nagaiank — Fri, 21 Sep 2018 23:58:45 GMT

Yes.

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

Re: Add days to date

rubenmarin — Sat, 22 Sep 2018 07:13:29 GMT

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