Date () change on 7.30 am

A

asrul

Hi All,
Have a good day.

I have ReinspectedDate_txt ( a text box ) on my form.
Its default value is set to Date().
We know that the date will automatically change at 12.00 pm.

Can we make it change on 7.30 am in the morning?
Would somebody like to advise me how to do that.

Regards,
 
B

Bob Quintal

Hi All,
Have a good day.

I have ReinspectedDate_txt ( a text box ) on my form.
Its default value is set to Date().
We know that the date will automatically change at 12.00 pm.

Can we make it change on 7.30 am in the morning?
Would somebody like to advise me how to do that.

Regards,
Click to expand...
if before 7:30 is yesterday,
=date() - iif(now()-date() < 0.3125,1,0)

How it works: Now() - date() returns the fraction of a day.
(7*60+30) / (24 * 60) is the fraction of a day
 
J

John W. Vinson

Hi All,
Have a good day.

I have ReinspectedDate_txt ( a text box ) on my form.
Its default value is set to Date().
We know that the date will automatically change at 12.00 pm.

Can we make it change on 7.30 am in the morning?
Would somebody like to advise me how to do that.

Regards,
Click to expand...

I'd set its default value to

=DateValue(Now() - #07:30#)
 
Top