Skip to main content
Nintex Community Menu Bar

Validate Date/time control to allow weekday only

  • February 15, 2022
  • 0 replies
  • 451 views

Forum|alt.badge.img+8

Topic

How to allow a user to select only dates that are weekdays on Nintex Forms

 

Instructions


1.To allow a user to select only dates that are weekdays (i.e. Monday-Friday) you can use a data validation rule with a custom formula using FormatDate Inline function.
Usage:
formatDate(date, format) or formateDate({namedControl}, "D")
2.Create a Date/time control
3.Add the following validation rule to the the date/time control 
or(equals(formatDate({Self},"dddd"),"Saturday"),equals(formatDate({Self},"dddd"),"Sunday"))
"dddd" will format the date as the day's name, "Sunday" for example.
 

 

Related Links