Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
how can we add 14 days to the current date?
Thanks
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
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.
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.
try this
=Date(date([Bill date]) +14)