topic add date in QlikView

add date

Tue, 17 Jan 2012 08:41:33 GMT

Hi All,

how can we add 14 days to the current date?

Thanks

add date

Tue, 17 Jan 2012 08:55:30 GMT

Hi,

Just do Date([Current Date]+14), it will return 14 days added to the current date. i.e. Below colde returns 31/01/2012.

Date(Today()+14)

Cheers,

add date

Tue, 17 Jan 2012 09:25:45 GMT

Hi,

I am having a field Bill date in that i m date of this month like '01/01/2012' when i wrote Date([Bill date]+14) this gives me '14/01/1900' but i want 15/01/2012.

add date

Tue, 17 Jan 2012 09:42:48 GMT

Hi,

I think your [Bill date] is not coming as proper date format. Please use below code:

Date(Date([Bill date], 'DD/MM/YYYY')+14, 'DD/MM/YYYY')

Please revert back for any issue.

add date

SunilChauhan — Tue, 17 Jan 2012 09:48:35 GMT

try this

=Date(date([Bill date]) +14)