how can we add 14 days to the current date?
Just do Date([Current Date]+14), it will return 14 days added to the current date. i.e. Below colde returns 31/01/2012.
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.
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.
=Date(date([Bill date]) +14)
Retrieving data ...