J
JethroUK©
add one day to input date (parameter)?
=Format([Input Date?]+1,"dd mmm yy") - generates an error
any tips?
=Format([Input Date?]+1,"dd mmm yy") - generates an error
any tips?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
Rick B
Use DATEADD
J
John Spencer
What is the error you get? Is it a Type mismatch error?
Try one of the following
= [Input Date] + 1
= DateSerial(Year([Input Date]),Month([Input Date]),Day([Input Date])+1)
= DateAdd("d",1,[Input Date])
Try one of the following
= [Input Date] + 1
= DateSerial(Year([Input Date]),Month([Input Date]),Day([Input Date])+1)
= DateAdd("d",1,[Input Date])
D
Dirk Goldgar
JethroUK© said:add one day to input date (parameter)?
=Format([Input Date?]+1,"dd mmm yy") - generates an error
Is [Input Date?] a parameter in the report's recordsource query?
You don't say what error you get, so I don't know if [Input Date?] is
being recognized at all. But if it is, you may need to explicitly
convert it to a date:
=Format(CDate([Input Date?])+1,"dd mmm yy")
J
JethroUK©
that works fine thanx
for the record - it was merely a parameter in the report header itsself,
which worked fine, but the additions didn't
for the record - it was merely a parameter in the report header itsself,
which worked fine, but the additions didn't
Dirk Goldgar said:JethroUK© said:add one day to input date (parameter)?
=Format([Input Date?]+1,"dd mmm yy") - generates an error
Is [Input Date?] a parameter in the report's recordsource query?
You don't say what error you get, so I don't know if [Input Date?] is
being recognized at all. But if it is, you may need to explicitly
convert it to a date:
=Format(CDate([Input Date?])+1,"dd mmm yy")
--
Dirk Goldgar, MS Access MVP
www.datagnostics.com
(please reply to the newsgroup)