Date Function

  • Thread starter Thread starter reno.04
  • Start date Start date
R

reno.04

Hi

can someone explain which date function i should use if i want the system
date to appear in a textbox as i enter it

Cheers
 
Reno try the On Enter event or Got Focus event of the text box

Private Sub myTextBox_Enter()
Me.myTextBox = Date
End Sub
 
hey Reggie

that didnt work

and could you explain (cause help doesnt ,atleast to my understanding)
what the interval, means in the following function

DateAdd («interval», «number», «date»)

What i'm trying to do is write a query that will tell me which clients
certifications are due for renew say after 3 yrs
Cheers
Reno
Ps Thank you for all your help
 
Interval is the interval of time you want to add for example year, month,
day, minute, etc. and number is the number of intervals so for example
should you use
NewDate = DateAdd( "yyyy", 3, Date()) would give you the date 3 years from
todays date.
NewDate = DateAdd( "m", 3, Date()) would give you the date 3 months from
todays date.

NewDate = DateAdd( "h", 4, Now()) would give you the time 4 hours from now.

Hope this helps
 
Back
Top