I need to create fields as day of the week from Monday to Sunday that will be checked against the date from date/time picker to check if there is availability.
I created fields monday to sunday as “yes/no” but they were wrong to compare with date.
Is it possible?
Hi there, @anon19893928… if you use the :extract operator to extract the day from a date, you get a number from 0 (Sunday) to 6 (Saturday). So, if you have a number field with a number from 0 to 6 in it, you would be able to check that field against the day (number) extracted from the date selected in a date/time picker.
Hope this helps.
This topic was automatically closed after 70 days. New replies are no longer allowed.