Add days to date

[akuligod]

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)

[nagaiank]

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