You need to sign in to do that
Don't have an account?
Michael Coluzzi
calculate a date from a picklist and a date field
Hi All,
I am looking to create a formula field that calculates a date in the future based on a date field value and a picklist. I was looking into using a CASE for this but keep recieving a syntax error.
CASE(Password_Expires_Every__c ,"30 Days", Password_Last_Changed__c + 30, "60 Days",Password_Last_Changed__c + 60,"90 Days", Password_Last_Changed__c + 90,"180 Days",Password_Last_Changed__c + 180,"One Year",Password_Last_Changed__c + 365)
Wondering if anyone can guide me to the issue!
Thank you
I am looking to create a formula field that calculates a date in the future based on a date field value and a picklist. I was looking into using a CASE for this but keep recieving a syntax error.
CASE(Password_Expires_Every__c ,"30 Days", Password_Last_Changed__c + 30, "60 Days",Password_Last_Changed__c + 60,"90 Days", Password_Last_Changed__c + 90,"180 Days",Password_Last_Changed__c + 180,"One Year",Password_Last_Changed__c + 365)
Wondering if anyone can guide me to the issue!
Thank you
Raj Vakati
Raj Vakati
Use the above formula .. It will work as you expected