working out the day from the date

  • Thread starter Thread starter Fie
  • Start date Start date
F

Fie

Hiya,
Basically I have a table tblRubbishPickUp which records the weight of
rubbish picked up
on certain dates, the table has the fields (Weight, Date, Driver) I
want to be able to work
out the actual day i.e Monday, Tues, Wed etc does anyone know the
formulae
that you enter in to the query to figure this out?

Fie
 
WeekDayName(Weekday(Date),True) will return Wed
WeekDayName(Weekday(Date),False) will return Wednesday
 
Back
Top