Configuring datevalues

Hi

I have a lbl on my form which shows todays date but
I need to configure this date....

I need the date to register as yesterdays date until 06.30am........

I know I cound probably use dateadd etc but I need something that will deduct the date until 06.30am and then show todays date..............Does anyone know of anything that could
accomplish this??

Hope I have made myself clear!!!!

Thanks

yep. Clear as mud....:confused:

yep. Clear as mud....:confused:

VB Code:

If Time < "06:30:00" Then
 
  Label1.Caption = (Format(Now - 1, "dd/mm/YYYY"))
  
Else
 
  Label1.Caption = (Format(Now, "dd/mm/YYYY"))
  
End If

:D :D :D

Thanks Fatboypee...I will give it a try

Was it as clear as mud....:p :p

Thanks for your help