add date

[#1]

Hi All,

how can we add 14 days to the current date?

Thanks

[#2]

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,

DJ

[#3]

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.

[#4]

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.

[SunilChauhan]

try this

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