update record automatically

Ask the community
,
1

Hi,
I have a filed name email which I want to automatically update the data based on the current date, means if the record belongs to before today, the email will be like xxxx@gg.com.old
Can anyone help me? Thanks