Date problem

[farhanahmed]

I want to add current date to all my new and old records.when tomorrow date chat it automatically changed in whole record.how it is possible.

[kennejd]

You could use an update query....the sql would be Update table set date = date(). I'm not sure why you would want to do this, though....what is the purpose, if you don't mind me asking?