Date Function

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


--
Reggie

----------
"reno.04" wrote in message
...
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

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
"Reggie" wrote in message
...
Reno try the On Enter event or Got Focus event of the text box

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


--
Reggie

----------
"reno.04" wrote in message
...
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

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
--
Reggie

----------
"reno.04" wrote in message
...
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
"Reggie" wrote in message
...
Reno try the On Enter event or Got Focus event of the text box

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


--
Reggie

----------
"reno.04" wrote in message
...
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