By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,124 Members | 2,208 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,124 IT Pros & Developers. It's quick & easy.

How to set Monday as day one of the week?

P: n/a
Dear reader,

By using the command:

DatePart("ww";[DateField])

Sunday is coming up as next week.

I prefer that a week start on Monday and ends on Sunday.

How can I set Monday as day one of the week?

Tanks for any help.

Simon
Aug 5 '07 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Hi
DatePart("ww";[DateField])
How can I set Monday as day one of the week?
Try :

DatePart("ww";[DateField];vbMonday)

Regards
Jens
Aug 5 '07 #2

P: n/a
On Sun, 5 Aug 2007 18:18:37 +0200, "Simon" <Sv********@Versatel.nl>
wrote:
>Dear reader,

By using the command:

DatePart("ww";[DateField])

Sunday is coming up as next week.

I prefer that a week start on Monday and ends on Sunday.

How can I set Monday as day one of the week?

Tanks for any help.

Simon

DatePart("ww", [DateField], vbMonday)
Aug 5 '07 #3

P: n/a
suggest you read up on the DatePart() function in Help, so you'll understand
how to use all the arguments, both required and optional.

hth
"Simon" <Sv********@Versatel.nlwrote in message
news:46*********************@news.tele2.nl...
Dear reader,

By using the command:

DatePart("ww";[DateField])

Sunday is coming up as next week.

I prefer that a week start on Monday and ends on Sunday.

How can I set Monday as day one of the week?

Tanks for any help.

Simon


Aug 5 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.