capture date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In my forms Event I capture the person deleting a record with this:
Criteria = lCriteria & "tblTrackingData.TR_AOR, " & """" & gcurrentuser &
"""" & " AS tUser "

Could you please show me how to capture the date (todays date)..

thank you
 
Check out both the DATE and NOW variables in Access help
You may also want to look at the DATEPART function

-Dorian
 
I am familiar with DATE,NOW and DATEPART, I was not real clear on why I'm
asking for help, let me explane:
When someone deletes a record my code writes the record data to a table.
The source code table does not have a date veriable but I created one on the
new table the data is written to. If I add the DATE() for example, this
changes everytime it's run. I need to capture a date the moment the record
is written to the new table...

Can you please help?
Thanks
 
Back
Top