Avatar

Level 10

I am really getting frustrated with the new forum software. They go to all the effort to enable attachments and it doesn't always work. We would be better off not having it all. Sorry. I digress.

Does the "dayOfTheWeek" hidden field (that does the FormCalc) need to be a particular type of field? (Would a text field work?)

In my sample "dayOfTheWeek" is a textt field and it is not hidden so you can validate the results.

You mentioned the need to sync the date pattern on the DateTimeField with the script. Which pattern applies? There is Display, Edit, Validation and Data.

Display and Validation are defined as "date{MM/DD/YYYY}".

If the "dayOfTheWeek" field is visible for testing purposes, is there a way I can see that the EEE pattern is correctly returning the Day of the Week?

As stated above. Note, you can also use "E" pattern to return an integer (1-7) where 7 is Sunday, if you prefer.

Steve