Date () change on 7.30 am

[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,

 

[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,

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

 

[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,

I'd set its default value to

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

 

[asrul]

Thank's All,
Both of them should be work.
I'll give them a test.

Have a good day.