I have a report on which I have two unbound text boxes that I want to populate with the dayname for a related date. One is called txtStartDateName, and the other...... yep, you guessed it, its txtEndDateName
txtStartDate name Control Source is:
With very similar for txtEndDate
Now, the odd thing is that when I run the report, the day names that appear in these boxes are the day before the actual date - - - so if I used today's date (26/03/2015), I would get Wednesday instead of Thursday as it actually is?
At first I thought it was my PC at work screwing around, but I have now tried a copy of the database on my new PC at home and it is exactly the same?
Any idea what I am doing wrong?
txtStartDate name Control Source is:
Code:
=WeekdayName(Weekday([txtStartDate]))With very similar for txtEndDate
Now, the odd thing is that when I run the report, the day names that appear in these boxes are the day before the actual date - - - so if I used today's date (26/03/2015), I would get Wednesday instead of Thursday as it actually is?
At first I thought it was my PC at work screwing around, but I have now tried a copy of the database on my new PC at home and it is exactly the same?
Any idea what I am doing wrong?
Day Name from Date
