Table with dates and dayname

[samirshah172]

Hello,

I am very new with access database. Want to create table with Dates & DayName. For example, tblYear2015 with all dates from 1-Jan-2015 to 31-Dec-2015 in FirstColumn and DayName in second column as per date of First Column. DayName Should be entered automatically as per date entered in first column.

Please help.

Regards
Samir Shah.

 

[Galaxiom]

What is the purpose of this table?

Whatever it is you would not store the day name because it can be returned from any date using built in functions of Access.

 

[samirshah172]

Ok got it, can you help me to populate DayName in report.

Thanks for the help.

 

[Galaxiom]

This will return the full day name:

= Format([datefield],"dddd")

If you want it abbreviated:

= Format([datefield],"ddd")

 

[samirshah172]

Ok thanks

 

[gemma-the-husky]

note also that the day is also represented as a number in the range 1 to 7, sunday being 1, and this number for a given date can be obtained by

weekday(mydate)

there are vb constants so you can use constructs like this

if weekday(mydate) = vbsaturday then ...

 

[samirshah172]

Cool, thanks for alternate suggestion.