add one day to input date?

[JethroUK©]

add one day to input date (parameter)?

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

any tips?

 

[Rick B]

Use DATEADD

 

[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])

 

[Dirk Goldgar]

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

 

[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

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)