Day of Week

system · June 13, 2002, 5:49pm

Patrick and Sarah,

Thanks for your input and explanation. I was able to get the report to work
just as intended.
Our employees leave at 2:30 on Fridays and at Shiftendtime the rest of the
week, I was able to eliminate the Fridays that they leave at 2:30 from
showing on the attendance report.
If you are interested in this report I'll be glad to share it. I'm sure that
you both could really soup it up from what I have so far.

Thanks to both of you for all your help.

Jim Moore
GD-OTS

-----Original Message-----
From: Winter, Patrick [mailto:pjw@...]
Sent: Thursday, June 13, 2002 4:26 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Day of Week

Is that what your looking for Jim?

Patrick

-----Original Message-----
From: Winter, Patrick [mailto:pjw@...]
Sent: Thursday, June 13, 2002 3:38 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Day of Week

Say you want the report to give you the prior weeks Saturday thru Friday no
mater what day of the week you run it this week. Create a calculated field
START_DATE:
IIF(WEEKDAY(TODAY) = 1,TODAY - 7,
IIF(WEEKDAY(TODAY) = 2, TODAY - 8,
Etc.... (whatever today is subtract back to your start date.)

system · June 13, 2002, 4:09pm

I need to know how pick a day of the week for a filter.
I need to filter payroll date's of Friday's.
I have looked at some old post but not come up with anything.

Thanks.

Jim Moore
GD-OTS

system · June 13, 2002, 4:16pm

Report builder WEEKDAY function 1 = Sunday thru 7 = Saturday.

Patrick

-----Original Message-----
From: Moore, Jim (Anniston) [mailto:jmoore@...-ots.com]
Sent: Thursday, June 13, 2002 3:09 PM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] Day of Week

I need to know how pick a day of the week for a filter.
I need to filter payroll date's of Friday's.
I have looked at some old post but not come up with anything.

Thanks.

Jim Moore
GD-OTS

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

system · June 13, 2002, 4:31pm

Ok, I am really dumb today!! I understand that Weekday 6 = Friday, but what
is the correct syntax for the weekday function to use in a filter?
And include any Friday in the past or future.

-----Original Message-----
From: Winter, Patrick [mailto:pjw@...]
Sent: Thursday, June 13, 2002 3:16 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Day of Week

Report builder WEEKDAY function 1 = Sunday thru 7 = Saturday.

Patrick

-----Original Message-----
From: Moore, Jim (Anniston) [mailto:jmoore@...-ots.com]
Sent: Thursday, June 13, 2002 3:09 PM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] Day of Week

I need to know how pick a day of the week for a filter.
I need to filter payroll date's of Friday's.
I have looked at some old post but not come up with anything.

Thanks.

Jim Moore
GD-OTS

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

system · June 13, 2002, 4:37pm

Say you want the report to give you the prior weeks Saturday thru Friday no
mater what day of the week you run it this week. Create a calculated field
START_DATE:
IIF(WEEKDAY(TODAY) = 1,TODAY - 7,
IIF(WEEKDAY(TODAY) = 2, TODAY - 8,
Etc.... (whatever today is subtract back to your start date.)

Create a calculated field for THRU_DATE and do the same.

Patrick

-----Original Message-----
From: Moore, Jim (Anniston) [mailto:jmoore@...-ots.com]
Sent: Thursday, June 13, 2002 3:31 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Day of Week

Ok, I am really dumb today!! I understand that Weekday 6 = Friday, but what
is the correct syntax for the weekday function to use in a filter?
And include any Friday in the past or future.

-----Original Message-----
From: Winter, Patrick [mailto:pjw@...]
Sent: Thursday, June 13, 2002 3:16 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Day of Week

Report builder WEEKDAY function 1 = Sunday thru 7 = Saturday.

Patrick

-----Original Message-----
From: Moore, Jim (Anniston) [mailto:jmoore@...-ots.com]
Sent: Thursday, June 13, 2002 3:09 PM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] Day of Week

I need to know how pick a day of the week for a filter.
I need to filter payroll date's of Friday's.
I have looked at some old post but not come up with anything.

Thanks.

Jim Moore
GD-OTS

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

system · June 13, 2002, 4:40pm

If you want ANY and ALL Friday's included, make a calculated field called
'weekday' with an expressions of; WEEKDAY(PAYROLLDATE).

In your filter, add a line "weekday = 6"

[Non-text portions of this message have been removed]

system · June 13, 2002, 5:25pm

Is that what your looking for Jim?

Patrick

-----Original Message-----
From: Winter, Patrick [mailto:pjw@...]
Sent: Thursday, June 13, 2002 3:38 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Day of Week

Say you want the report to give you the prior weeks Saturday thru Friday no
mater what day of the week you run it this week. Create a calculated field
START_DATE:
IIF(WEEKDAY(TODAY) = 1,TODAY - 7,
IIF(WEEKDAY(TODAY) = 2, TODAY - 8,
Etc.... (whatever today is subtract back to your start date.)

Create a calculated field for THRU_DATE and do the same.

Patrick

-----Original Message-----
From: Moore, Jim (Anniston) [mailto:jmoore@...-ots.com]
Sent: Thursday, June 13, 2002 3:31 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Day of Week

Ok, I am really dumb today!! I understand that Weekday 6 = Friday, but what
is the correct syntax for the weekday function to use in a filter?
And include any Friday in the past or future.

-----Original Message-----
From: Winter, Patrick [mailto:pjw@...]
Sent: Thursday, June 13, 2002 3:16 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Day of Week

Report builder WEEKDAY function 1 = Sunday thru 7 = Saturday.

Patrick

-----Original Message-----
From: Moore, Jim (Anniston) [mailto:jmoore@...-ots.com]
Sent: Thursday, June 13, 2002 3:09 PM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] Day of Week

I need to know how pick a day of the week for a filter.
I need to filter payroll date's of Friday's.
I have looked at some old post but not come up with anything.

Thanks.

Jim Moore
GD-OTS

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

Topic		Replies	Views
Date filter in RB Yahoo Archive	4	330	February 28, 2005
TODAY Function Yahoo Archive	7	418	October 6, 2003
Taking Sat and Sun out of date look aheads Yahoo Archive	1	330	November 18, 2011
Report Filters Yahoo Archive	2	350	March 4, 2005
Blank Title 5148 Yahoo Archive	0	271	January 26, 2001

Day of Week

Related Topics