New to Qlikview - add days to a date??

[#1]

I cant seem to convert a date into itself plus 30/60/90 days. Have used the date(original_date+30, DD/MM/YY) syntax but get garbage.

My suspicion is my date is loaded as a text/non date format and Qlikview cant recognise it. Any ideas. Should I work on converting the string into a date on load (how?) or using some function to manipulate post load or in the charts (how?)? Help please and thanks in advance?

[boorgura]

Please try one of these:

date(date(Original_Date) +30, 'MM/DD/YYYY')

date(Original_Date+30, 'MM/DD/YYYY')

In the output, you might still see a number. try to use date() function on the UI as well.