You need to sign in to do that
Don't have an account?
kperri
Validattion rule help to have a date field required when another field is updated.
I am trying to build a validation rule that will require a date when 1 of 3 fields are updated. Initially I did
AND(
Asset_Update_Date__c = PRIORVALUE(Asset_Update_Date__c),
OR(
ISCHANGED( Unmanaged_Muni_Assets__c ),
ISCHANGED( A_Share_Assets__c ),
ISCHANGED( C_Share_Assets__c )))
That only works if a date is already in the field.
These fields will initially start off blank as will the date. What I would like to see happen is when a user updates any of the fields that it requires the Asset_Update_Date field to be updated to the current date.
Thanks
AND(
ISBLANK(Asset_Update_Date__c),
OR(
ISCHANGED( Unmanaged_Muni_Assets__c ),
ISCHANGED( A_Share_Assets__c ),
ISCHANGED( C_Share_Assets__c )
)
ANd(
OR(
ISBLANK(Asset_Update_Date__c),
Asset_update_Date__c == PRIORVALUE(Asset_Update_Date__c)
),
REST OF THE FORMULA,
Asset_Update_Date__c <> Today()
)
Thanks for the reply. Is there a way for the rule to look at the Asset Update Date and if that date is not equal to today, that it be required to be updated to today?
Additionally, changing the rule as indicated wouldn't require a date change of the Asset Update Date. I am trying to get it where if any of the 3 fields are updated that the Asset Update Date be filled with the current date.
This worked I think. Thanks I am trying to wrap my brain around these validation rules as a new admin.
Thanks
ANd(
ISCHANGED() functions of the three fields,
Asset_Update_Date__c <> TODAY()
)
CHECK IF Any of THE FIELDS ARE CHANGED,
If yes, check if Asset_update_Date__c is equal to today.
I ran into an issue with the validation rule. When updating any of the fields the Asset Update Date will not accept todays date.
So I created the below validation. (I added an additional field I needed.
AND(
ISCHANGED( A_Share_Assets__c , C_Share_Assets__c , FA_s_Total_AUM__c , Unmanaged_Muni_Assets__c ),
Asset_Update_Date__c <> TODAY()
)
CHECK IF Any of THE FIELDS ARE CHANGED,
If yes, check if Asset_update_Date__c is equal to today.
When clicking Check Syntax I get an error Extra Check
AND(
OR(
ISchanged(A_Assets__C),
ISCHANGED(C_Assets__c),
ISCHANGED(FA_Total_AUM__C),
ISCHANGED(Unmanaged_Muni_Asset__c)),
Asset_Update_Date__c <> TODAY()
)
What about the
CHECK IF Any of THE FIELDS ARE CHANGED,
If yes, check if Asset_update_Date__c is equal to today.
That was in your previous post.
Thanks
Thanks for all you help on this. This is getting closer. Now it will require today's date, if it isn't already. However, it doesn't give you the error if there is currently no date listed.
From day 1 all fields will be blank (including the date field) Users will begin to populate those fields at which point I would want them to be required to enter a date. I thought that ischanged would compare a blank field to a new number. It appears ischanged is only working if there is a number there and it is changed. So how can you make the rule fire when it goes from blank to a number?