If statement that will return data based on the time of the day.

[lweinbrecht]

Hello,

I am trying to write an expression that will result in a date in the format (mm/dd/yyy). I want to display the curent day if it is before 11:00 am based on the system time, and the next day if it is after 11:00 am. Below is the expression that I currently am working with... but it is not working. Please help. LW

IIf(Time()>Hour(11),Date(),DateAdd("d",1,Date()))

ps. i might be going to the total wrong direction....

[Dal Jeanis]

Try this

IIf(Time()<#11:00:00 AM#,Date(),DateAdd("d",1,Date()))

[June7]

The Hour() usage doesn't make sense. Hour() is used to extract the hour from a valid date.

IIf(Time()<"11:00:00 AM", Date(), Date() + 1)

or

Date() + IIf(Time()<"11:00:00 AM", 0, 1)


Day is default unit when adding with date value so don't need DateAdd.

[Dal Jeanis]

June7 - Quite true, but I try to use DateAdd for any such thing, since MS Access can get quite finnicky at unpredictable times, and DateAdd is self documenting the next time I have to read my own code.

[June7]

Good point, try:

DateAdd("d", IIf(Time()<"11:00:00 AM", 0, 1), Date())

[Dal Jeanis]

Clean. Either #2 or #5 should get the correct result.