Day Name from Date

jeudi 26 mars 2015

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:




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

0 commentaires:

Enregistrer un commentaire

Labels