Date format 1

[lebanoncedars]

Hi there,
On my form I have two dates.
One for the first time we entered customer information.
Second date for the last time we modified customer information.

Question: How can I make those date to work automatically without type down the dates.

Thank you
Lebanoncedars

 

[JoanneM]

to do this you are going to need to use a mini audit trail

the 'on dirty' event of the form will let you know if anything on the form has been changed

a field (or textbox - hidden if neccessary will store the date for this event)bound to the 'edit date' field in your table

eg

me.dtEditBox = format(date,"dd/mm/yy&quot

on saving of a new record you can populate the creation date
by a similar method

me.dtcreateBox = format(date,"dd/mm/yy&quot


NB don't do it on creation cos if they don't use you have to lose it for them

Jo

 

[lebanoncedars]

Hi Joanne,

I need more details Please.
or any easier way,
I use to use something like that in the date_entered field as default and it works as today's date
=Now()
but for Date modified !
I don't how?
more details..thanks if U can.
Thanks
Lebanoncedars