Date () change on 7.30 am

  • Thread starter Thread starter asrul
  • Start date Start date
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,
 
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
 
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#)
 
Back
Top