Date Format

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
 
K

Ken Snell [MVP]

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]))
 
Top