add one day to input date?

  • Thread starter Thread starter JethroUK©
  • Start date Start date
J

JethroUK©

add one day to input date (parameter)?

=Format([Input Date?]+1,"dd mmm yy") - generates an error

any tips?
 
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])
 
JethroUK© said:
add one day to input date (parameter)?

=Format([Input Date?]+1,"dd mmm yy") - generates an error
Click to expand...

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")
 
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


Dirk Goldgar said:
JethroUK© said:
add one day to input date (parameter)?

=Format([Input Date?]+1,"dd mmm yy") - generates an error
Click to expand...

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)
Click to expand...
 
Back
Top