Sep 28 2020 06:03 AM
Sep 28 2020 06:25 AM
Oct 01 2020 02:57 AM
Thanks for the reply. The way I need the info is having a date field and a day field. At present I choose the day from a drop down but want to automate it. When I choose a date , I want the day to populate another field . The idea is that later, I can use the day field for employee daily work loading @Daniel_Pineault
Oct 01 2020 07:23 AM - edited Oct 01 2020 07:25 AM
you don't need a separate field (in the table) for the day as you can always let it be shown from any date you have. e.g. to show the day in a separate text box on the form:
So, to show the day is just a matter of formatting the date.
I'm not sure that I get exactly what you mean by
> ...later, I can use the day field for employee daily work loading
If this means you have to "extract" and analyze the days you probably can use the Weekday function e.g. in a calculated column of a query.
Oct 02 2020 12:08 AM
@Karl Donaubauer I created a query to show employee jobs per day. I then use this to generate a report which shows me which employee to use next. This enables me to not overuse one employee.
What I want is when I choose the date using the date picker it automatically pulls in the day for that date chosen.