Calculating Week Of

Yahoo Archive
1
THANKS!!

________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of bpbuechler
Sent: Wednesday, July 30, 2008 8:02 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Calculating Week Of


Here is what I have in several BAQ's:

(APInvHed.DueDate) - weekday(APInvHed.DueDate) + 1
Format = 99/99/9999
Data Type = Date

Hope this helps.
Patty Buechler

--- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, Jasper Recto <jrecto@...> wrote:
>
> How would you calculate the Week of a certain date in report
builder?
>
> I'm breaking out our required shipments by week and I want the
heading to say: Week of: xxx
>
> Any suggestions?
>
> Thanks,
> Jasper
>
>
> [Non-text portions of this message have been removed]
>





[Non-text portions of this message have been removed]
2
How would you calculate the Week of a certain date in report builder?

I'm breaking out our required shipments by week and I want the heading to say: Week of: xxx

Any suggestions?

Thanks,
Jasper


[Non-text portions of this message have been removed]
3
Here is what I have in several BAQ's:

(APInvHed.DueDate) - weekday(APInvHed.DueDate) + 1
Format = 99/99/9999
Data Type = Date

Hope this helps.
Patty Buechler

--- In vantage@yahoogroups.com, Jasper Recto <jrecto@...> wrote:
>
> How would you calculate the Week of a certain date in report
builder?
>
> I'm breaking out our required shipments by week and I want the
heading to say: Week of: xxx
>
> Any suggestions?
>
> Thanks,
> Jasper
>
>
> [Non-text portions of this message have been removed]
>