I would like to ask for your assistance building a formula that calculates the next working day from a given date.
Example: A record created on Sunday should return the date of the following Monday (if created today 19/02) the field should return 20/02.
For what I require I also need another field to return the second day after the given date but I suppose that from the first formula I will figure out the second one.
I would like to ask for your assistance building a formula that calculates the next working day from a given date.
Example: A record created on Sunday should return the date of the following Monday (if created today 19/02) the field should return 20/02.
For what I require I also need another field to return the second day after the given date but I suppose that from the first formula I will figure out the second one.
I have a requirement which required to remove newline character before validating the value in textarea. But formula TRIM function only remove white space and tabs unlike apex trim() function. Also I am unable to use SUBSTITILE as \n or \r is not identified in validation rule formula. Please kindly suggest me some way to identify or remove newline character.
