Show Todays Date As Day Name? (1 Viewer)

[Number11]

Hi,
So i need to show within a form todays date as the day name and then a second box to show yesterdays day and the another box to show week commencing date. any ideas

 

[Gasman]

A quick google shows the function WeekdayName() to get the names.

MS Access: WeekdayName Function

This MSAccess tutorial explains how to use the Access WeekdayName function with syntax and examples. The Microsoft Access WeekdayName function returns a string representing the day of the week given a number from 1 to 7.

www.techonthenet.com

Then use WeekDay() function and math to determine the rest?

 

[arnelgp]

you can also use =Format$(Date(), "dddd") as today's dayname and
=Format$(Date()-1, "dddd") as yesterday.

to show the start of week (change vbSunday to whaterver day (integer) you want to start the week):

=date()-weekday(date(),vbSunday)+1

 

[isladogs]

If you want the full date as well as the day name, use e.g. Format(Date(),"dddd dd/mm/yyyy") substituting your preferred date format

?Format(Date(),"dddd dd/mm/yyyy")
Thursday 25/11/2021