Formatting date to week

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

shiro - 30 Oct 2007 08:09 GMT

Hi All,
I'm trying to create a select query which have field date.
Now I want have a field which return the date value to
week format.How to create it.I want the week change
every monday at 7.30 am.How to make access achieve
it.Hope somebody like to help.

Reply to this Message

Jerry Whittle - 30 Oct 2007 14:47 GMT

If by "week format" you mean the number of the week, something like below
will work somewhat:

TheWeekNumber: DatePart("ww", [TheDateField], vbMonday)

It does not take into account your need for it starting at 7:30am. If the
date field has a time element, something like this may meet your needs:

TheWeekNumber: DatePart("ww", [TheDateField] - 0.3125, vbMonday)

Signature

Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

> Hi All,
> I'm trying to create a select query which have field date.
> Now I want have a field which return the date value to
> week format.How to create it.I want the week change
> every monday at 7.30 am.How to make access achieve
> it.Hope somebody like to help.

Reply to this Message

shiro - 31 Oct 2007 03:39 GMT

Dear Jerry,
more explanation please.Can't we build it by using
exspression builder.Coding is terrible for me.

> If by "week format" you mean the number of the week, something like below
> will work somewhat:
[quoted text clipped - 15 lines]
> > every monday at 7.30 am.How to make access achieve
> > it.Hope somebody like to help.

Reply to this Message