Date Format

  • Thread starter Thread starter Aurora
  • Start date Start date
A

Aurora

I am using Access 2000

In a query, I have the following formula
DateSSigned: IIf([IASupv-Sign] Is Null," ",Date())

to insert the current date when a signature is put in to
the IASupv-Sign field. But this date is changing each
time we bring up the record, I believe because " Date()"
brings up the current (today's) date. What should I be
using to bring up the current date when the appropriate
field is signed but keep that date in the field without
changing?

Please help!
Aurora
 
You'd need to test if there already is a date in the field, and use that
field instead of Date() function. Something like this, perhaps:

DateSSigned: IIf([IASupv-Sign] Is Null," ",IIf([DateSignedField] Is
Null, Date(), [DateSignedField]))
 
Back
Top