Date Field/Column - Weekdays Only

Bryenne Albright

Is there a formula to use that formats the Date Field/Column to not allow weekdays to be chosen when added to a form?

Is there also a formula that would only show dates starting 4 weeks out from current date?

Mark Cronk

Hi @Bryenne Albright ,

You can't validate form entries while the form is being completed. You can use an automation rule to request an update if the submitter enters an erroneous value, e.g. a weekend date when only weekdays are expected or a date within a 4 week window.

Nor is it possible to restrict date input to a date 4 weeks out. You can add an update automation, as above.

To confirm a date is 4 weeks out you could use something along the lines of:

If(Week([date submitted]@row)<week(today())+4, "error", "valid")

IF([date submitted]@row<Today(28), "error", "valid")

In your automation logic, if the check value was "error" it would trigger the update request.

Help?

Mark