Date - stay static

[itsgrady]

I have a date field with today() that returns current date. I need for it to remain date when shift starts. The shift is from 6PM to 6AM. When form is being updated throughout the shift, the date changes to the next after 12 midnight. Is there a way to enter date automatically without it being updated after 12 midnight?

 

[MARK858]

Try pressing Ctrl + ;
If you want it to remain the same date via formula then you can't do it (unless you amend your iterations settings, which I won't recommend), you'll need VBA.

 

[FormR]

Hi, assuming that after 6AM you want it to update to the current date again, you could try:

=TODAY()-(MOD(NOW(),1)<TIME(6,0,0))

 

[itsgrady]

Try pressing Ctrl + ;
If you want it to remain the same date via formula then you can't do it (unless you amend your iterations settings, which I won't recommend), you'll need VBA.

Thanks for your reply.

 

[itsgrady]

Hi, assuming that after 6AM you want it to update to the current date again, you could try:

=TODAY()-(MOD(NOW(),1)<TIME(6,0,0))

The formula is working great. Thanks for your help!