T Tarah New member Local time Today, 16:10 Joined Aug 18, 2004 Messages 8 Nov 17, 2004 #1 I have a date field that currently auto populates to today's date. My problem is that 3rd shift data (which is entered after midnight) needs to have the previous date. any suggestions??
I have a date field that currently auto populates to today's date. My problem is that 3rd shift data (which is entered after midnight) needs to have the previous date. any suggestions??
L llkhoutx Registered User. Local time Today, 15:10 Joined Feb 26, 2001 Messages 4,018 Nov 17, 2004 #2 Use the Now() function and check the time portion before saving/ decrimenting (merely subtract 1) the date. Save either Date() or Date()-1.
Use the Now() function and check the time portion before saving/ decrimenting (merely subtract 1) the date. Save either Date() or Date()-1.
T Tarah New member Local time Today, 16:10 Joined Aug 18, 2004 Messages 8 Nov 18, 2004 #3 thanks i'll give that a try
