Date(), how to save it?

[Janjang]

if i use Date() as default value at my field, can i save it? i mean it not change when next day come for some record. coz i want to use today's date as default date to some record. when next day come, date for that recoerd still at yesterday's date..


or there have any other way to do it?

TQ

 

[The_Vincester]

Oh, one I can actually answer...

In the default date field (in table design mode), just put #06/06/2006# (or whatever date you want to be "default").

The default date will remain that date. I hope that answers your question.

 

[Janjang]

how bout if i use date() insteaed of key-in date manually?

 

[namliam]

If you put Date as the default value, the current date will be "entered" automagicaly. Just as if the user had keyed it in... So yes, it will also automagicaly get saved if you save your record.

Once filled tho, if the user open the record again tomorrow. The date will stay on today....

 

[Janjang]

really?

TQ

just curious.. not try it yet

 

[The_Vincester]

Ah, if that's what he's looking for, I'm not sure I understood the question... I thought he wanted "today" only as his "Date."

Yeah, Janjang it'll only change on "new" entries with Date(). All previous entries will remain the same.