Automatically update "date" field in entity named "Leads" daily

[dikshant]

I want to update a field named as "date" inside entity named "Leads" automatically...
The date field should always have today's date everytime it gets updated...Maybe using cron job or what I dont know...
I am currently doing it manually using recalculate formula...
Please Help me...I would be very thankful to you...

[Maximus]

Hi,
1. Formula triggers upon record updating. It weird that you need to run Recalculate Formula for this.
2. By default each entity has a field called 'modifiedAt' which automatically chaging each time the entry is changed.

[dikshant]

Hello,
I think you misunderstood the question...
I have create one custom field "date" which has today's date value...when I recalculate formula, it gets updated with today's date...but after 1 day, the date is yesterday's date...but I want today's date in date field automatically without recalculating formula....

[Maximus]

I see. Well, you cannot do it with Formula. You need to use either scheduled Workflow or BPM for this or tried to develop this functionality.