You need to sign in to do that
Don't have an account?
KALYANI GURRAM
Formula field to show date
Hi,
I need to create a date field and show Earliest is 5 business days in the future.
Please help me to achieve this.
Thank you,
I need to create a date field and show Earliest is 5 business days in the future.
Please help me to achieve this.
Thank you,
Could you please help with example what you want to achieve?
As per my understanding your formula field return type should be date and what value you want to be reflected in that field?
Thanks!
Sample Date Formulas | Examples of Advanced Formula Fields | Salesforce Developers (https://developer.salesforce.com/docs/atlas.en-us.usefulFormulaFields.meta/usefulFormulaFields/formula_examples_dates.htm)
Example:
This formula finds three business days from a given date. I would update it to use the WEEKDAY() Basicaly,
if 1 (Sunday) add 5 days which should be Friday
if 7 (Saturday) add 6 days which should be Friday (1 day for the Sunday and then 5)
else add 7 (which is 2 days for the weekend and 5 working days)
Note, the above does not factor in public holidays.
Adapt as required
regards
Andrew
I have a website about Tracking i want add more tracking service in my website can you pleace help me about that you can visit (https://trackscourier.com/) my website ..
best regards
best regards
TODAY() represents the current date.
MOD(TODAY() - DATE(1900, 1, 7), 7) calculates the number of days that have passed since January 7, 1900 (which was a Sunday) and returns the remainder when divided by 7. This helps determine the day of the week for the current date, where 0 represents Sunday, 1 represents Monday, and so on.
CASE(...) evaluates the result from the previous step and assigns a numeric value based on the day of the week. This is necessary because weekends (Saturday and Sunday) are not considered business days.
MOD(..., 7) is used again to get the remainder when the previous calculation is divided by 7. This step ensures that values greater than 5 are reduced to the range of 0-5.
CASE(...) is used once more to assign a different number of additional days depending on the value obtained from the previous step. This effectively skips weekends and adds the necessary number of business days (5 in this case). I also saw it on st courier tracking (https://anycouriertracking.com/st-courier-tracking/)
Finally, TODAY() + ... adds the calculated number of days to the current date, resulting in a new date that is 5 business days in the future.
You can create a new formula field in Salesforce and use this formula to achieve the desired functionality. Remember to adjust the field type to "Date" when creating the formula field.
I hope this helps! Let me know if you have any further questions.
Hi There,
We are working on website that are give health services in pakistan you can vistis it and check out services rapid healing medical services (https://rapidhms.com/)
We are working on website that are give health services in Orlando you can vistis it and check out services Serene Behavioral Health (https://serenehs.com/)