How to auto-populate Today’s date as a field value in MS Access table

[SachAccess]

Hi,
I have a MS Access table.
Am trying to add a field to existing MS Access table. There are already values present in this table.
I added a field in this table.

Selected Design view. Selected Data Type as Date/Time.
In Design View, at bottom, I have option for General and LokUp
Selected General
Selected Default value, clicked on 3 dots, selected =Date() as option
However still the newly added field is blank.

Can anyone please help me understanding what mistake am doing. Or is it even achievable.
I do not know if am making a mistake or the outcome is not possible itself.
Am trying to add a field which will automatically keep changing the date for all the records in the table everyday.
Thanks.

 

[Minty]

Default values only work for new records, not existing ones.
If you want an existing record to be updated to today's date then you would need to use an update query.

But your final phrase is worrying me

to add a field which will automatically keep changing the date for all the records in the table everyday.

Surely this serves no real purpose - what is this date going to represent?
A field that simply shows you today's date isn't really a field of data, it's just a piece of information that doesn't need saving with a record.

 

[moke123]

Am trying to add a field which will automatically keep changing the date for all the records in the table everyday.

All records? Or just newly added records each day?

If the field functions as a timestamp, I would use now()

 

[SachAccess]

Default values only work for new records, not existing ones.
If you want an existing record to be updated to today's date then you would need to use an update query.

But your final phrase is worrying me

Surely this serves no real purpose - what is this date going to represent?
A field that simply shows you today's date isn't really a field of data, it's just a piece of information that doesn't need saving with a record.

Thanks a lot for the help. I understood your point. I need to re-think my approach.

'today's date isn't really a field of data, it's just a piece of information that doesn't need saving with a record.'
I agree with you, I did not realize this. Have a nice day ahead.

 

[SachAccess]

All records? Or just newly added records each day?

If the field functions as a timestamp, I would use now()

Thanks a lot for the help. I guess I was going the wrong way. I will re-work on this.
I have just started learning and somehow my MS-Excel memory is tricking me.
Unknowingly I try implement same approach here without realizing the mistakes.

Have a nice day ahead.