How to get day names?

D

danijela.simunovic

I'm sorry for posting so many questions but this group has been very
helpfull so far and i have a lot of questions so i appriciate your help
very much!

I have a table with dates(1.1.2001.),how can i make a query which would
have two columns:the first would be the dates from the dates table and
the second would be the day names(Monday,Tuesday...Friday...) I know
that the day names are "dddd" but what do i do with that to get the day
name from a specific date?
Thanks!

Danijela
 
D

danijela.simunovic

I solved this problem, it was easy. I used the Weekday and WeekdayName
function but i still don't know what abbreviate means- i put for
abbreviate and the query works just fine.

WeekdayName(weekday, abbreviate, firstdayofweek)
WeekdayName(Weekday(qryDate!Date);2;1)
 
F

fredg

I'm sorry for posting so many questions but this group has been very
helpfull so far and i have a lot of questions so i appriciate your help
very much!

I have a table with dates(1.1.2001.),how can i make a query which would
have two columns:the first would be the dates from the dates table and
the second would be the day names(Monday,Tuesday...Friday...) I know
that the day names are "dddd" but what do i do with that to get the day
name from a specific date?
Thanks!

Danijela
Click to expand...

Select YourTable.[DateField], Format([DateField],"dddd") as DayName
From YourTable;
 
Top