Force day of the week validation (format-date) issue


I have a specific use case where we are looking to build a validation of date entry for specific day of the week (Friday) in the past

I created a calculation format-date(${Reporting_Date}, “%a”) and then used that in the validation of {Reporting_Date} with the following ${reporting_Date_validation} = “Fri”

This appears to work, but only for Fridays in the future. We are doing data entry from the previous date and doesn’t work. Please advise what the best way forward is.

Thank you.


I dont see anything obviously wrong with your approach, but without seeing your actual form its hard to tell exactly what the problem might be… But try this, which tested works for both dates in the past or future:

daycheck.xls (5.5 KB)

1 Like