Hi Radzmar,
I always enjoy and learn from your posts!
I have a slight twist to the day of week issue that you resolved above.
I have a date field called "First_Day", and seven text fields, one for each day of the week. I can get the above to work on the first text field, but what I want to do is change the date that is evaluated to First_Day + 1, First_Day + 2, etc.
My goal is to enter or pick a date in the date field "First_Day". Then, use that date to extract the day of week for each of the seven text fields, labeled "Day_1", Day_2", etc., incrementing the date as you go along.
So if...
First_Day = 08/25/15
Then, the text field values should be..
Day_1 = Tuesday
Day_2 = Wednesday
Day_3 = Thursday
Day_4 = Friday
Day_5 = Saturday
Day_6 = Sunday
Day_7 = Monday
As an added bonus, I would like to convert the days of the week to uppercase.
Thanks for your time!