function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Gambit99Gambit99 

Date Checking using a validation rule

Hi
i want to have a field change automatically if the date has passed.

im trying to use this

IF( today() - ETD__c 0 , Alerts_if_any__c ="Date Passed",Alerts_if_any__c =" x")
its not giving an error, but for somereason its not doing anything at all

can anyone help plz

thanks
David VPDavid VP
If I'm not mistaken it should be something like :

IF( TODAY() > ETD__c, ... , ...)

Use the '>' comparison operator.

David
DupeNukemDupeNukem
I think you will need a trigger and/or a class method to change the data like you're describing.

A validation rule will determine if there's an error and keep the record from saving.  However, it will not automatically populate a field with a specified value.
David VPDavid VP
You're right.

The formula made me think 'Workflow rule + field update' (which could work) ...


-David