getting the name of the day

[bbwolff]

i read about weekdayname issues here http://www.access-programmers.co.uk/forums/showthread.php?t=233212.
And this solution works if i set first day of the week to sunday. Now i don't want to do that as we start weeks on monday and I guess most comps have it set like that. Now if I'd be sure that all comps have it like that I could play with adding vbmonday to each day.
But what if the settings differ between comps? what can be done that.
Anyway it sounds really weird that the function like that that should be a constant delievers such weird result. Is there a better way to return day of the week

I'm using this

dan = WeekdayName(Weekday(Date, vbMonday))

 

[pbaldy]

Does this do what you want?

Format(date,"dddd")

 

[bbwolff]

not sure i understand
you mean that i format field in a table like that? hm, i have a table to store some values that i could use for this.
I only need this monday, 25th of november displayed like that on top of a report, so i just use date to fetch that day. i could write it in a table first and read from there to get the desired format i guess.
or maybe i misunderstood completely?

 

[pbaldy]

Wherever you were going to use the nested formula to get the day, you can try the Format() function.

 

[bbwolff]

great, tx

Me.txt= Format(Date, "dddd, d. mmmm yyyy") is what i need

 

[gemma-the-husky]

the actual day name is not dependent on the setting for the first day of the week.