You need to sign in to do that
Don't have an account?
sales force 48
getting date for selected day as per requirement
Hi developers
for opportunity object
i have a custom field (picklist) with all week days likely {monday,tuesday,wednesday,thursday,friday,saturday}
so,
i need a formulae field (code)
intially when record is created i want to get the date for that created date
again when i update the existing record and selected some weekday from the customfield (picklist) so the formulae field i should get the corresding weekday date
for opportunity object
i have a custom field (picklist) with all week days likely {monday,tuesday,wednesday,thursday,friday,saturday}
so,
i need a formulae field (code)
intially when record is created i want to get the date for that created date
again when i update the existing record and selected some weekday from the customfield (picklist) so the formulae field i should get the corresding weekday date
2)when i update the inserted record and selected a day from the picklist (let say monday) and click save, so the formulae field to be updated with date 11/10.2014 (becoz comming monday is 11/10/2014) and if i select tuesday from picklist the formule field to be updated with 11/12/2014 as 11/12/2014 is tuesday
There is some good advice on adding values to a date to find the next day of the week here:
https://help.salesforce.com/HTViewHelpDoc?id=formula_examples_dates.htm&language=en_US#getting-next-DoW-after-date (https://help.salesforce.com/HTViewHelpDoc?id=formula_examples_dates.htm&language=en_US#getting-next-DoW-after-date)
The one thing you'll need to do is convert that picklist value to a number value. You can do that in the formula or you could create another field that does it separately.