How to create fields with day of the week to compare with date from date/time picker

Hello

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?

:slight_smile:

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.

Best…
Mike

This topic was automatically closed after 70 days. New replies are no longer allowed.