I am building a process model that contains a start date and an end date picker.

I am building a process model that contains a start date and an end date picker. I want to ensure that the start date is always a Monday and the end date is always a Sunday. I don't see any functions that allow me to check for this type of behavior. Has anyone run into this situation? If so how did you solve the problem?

Thank you!...

OriginalPostID-117011

OriginalPostID-117011

  Discussion posts and replies are publicly visible

Parents
  • 0
    Certified Lead Developer
    To validate if the date picked is a monday or not you could use a custom expression rule that checks to see if the appian function weekday(dateSelected)=2 (Monday is the second day of the week).

    You can do something similar for sunday (weekday() = 1) but if its going to just be one week you can update the end date to startDate + 6.
Reply
  • 0
    Certified Lead Developer
    To validate if the date picked is a monday or not you could use a custom expression rule that checks to see if the appian function weekday(dateSelected)=2 (Monday is the second day of the week).

    You can do something similar for sunday (weekday() = 1) but if its going to just be one week you can update the end date to startDate + 6.
Children
No Data