TODAY Function

system · October 6, 2003, 10:29am

Does any one have an example of a report that use's this, so I can use it to see how to make my own? I think I'm going to report writer class at the end of the month. But example's are priceless...

Jim Horton
Mol-Son, Inc.
jim.horton@...

-----Original Message-----
From: Shirley Graver [mailto:shirleyg@...]
Sent: Monday, October 06, 2003 7:54 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] TODAY Function

The calculation would be TODAY - 1. I use it all the time.

Shirley Graver
Systems Administrator
Rubber Associates Inc.

-----Original Message-----
From: Jasper Recto [mailto:jrecto@...]
Sent: Monday, October 06, 2003 8:49 AM
To: Vantage Groups (E-mail)
Subject: [Vantage] TODAY Function

Good Morning,

I have a report that is design to filter by date using the TODAY()
function. This allows us to avoid changing the filter date every day.
In order to get the information, the report needs to be printed at the
end of the day. Except for actually changing the report date filter
every day, is there a way to have the report use yesterday's date? That
way to alter the TODAY function so the report can be printed the next
day instead of the end of the day.

Thanks,

Jasper

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

Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/M=251812.3856299.5103760.1261774/D=egroupweb/S=1705
007183:HM/A=1754452/R=0/SIG=11tjeu2hk/*http:/www.netflix.com/Default?mqs
o=60178324&partid=3856299> click here

<http://us.adserver.yahoo.com/l?M=251812.3856299.5103760.1261774/D=egrou
pmail/S=:HM/A=1754452/rand=328616663>

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/.
<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 the Yahoo!
<http://docs.yahoo.com/info/terms/> Terms of Service.

Tracking #: CF8EE88086DE894E8DAA61EEC270BFFC163DB165

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

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 · October 6, 2003, 8:48am

Good Morning,

I have a report that is design to filter by date using the TODAY() function. This allows us to avoid changing the filter date every day. In order to get the information, the report needs to be printed at the end of the day. Except for actually changing the report date filter every day, is there a way to have the report use yesterday's date? That way to alter the TODAY function so the report can be printed the next day instead of the end of the day.

Thanks,

Jasper

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

system · October 6, 2003, 8:52am

create a calculated field:

yesterday = today() - 1

then have your filter for yesterday.

-----Original Message-----
From: Jasper Recto [mailto:jrecto@...]
Sent: Monday, October 06, 2003 7:49 AM
To: Vantage Groups (E-mail)
Subject: [Vantage] TODAY Function

Good Morning,

I have a report that is design to filter by date using the TODAY() function.
This allows us to avoid changing the filter date every day. In order to get
the information, the report needs to be printed at the end of the day.
Except for actually changing the report date filter every day, is there a
way to have the report use yesterday's date? That way to alter the TODAY
function so the report can be printed the next day instead of the end of the
day.

Thanks,

Jasper

system · October 6, 2003, 8:53am

Create a calculated field called YESTERDAY = TODAY() - 1, put the new
calculated field in the filter.

Patrick Winter

-----Original Message-----
From: Jasper Recto [mailto:jrecto@...]
Sent: Monday, October 06, 2003 7:49 AM
To: Vantage Groups (E-mail)
Subject: [Vantage] TODAY Function

Good Morning,

I have a report that is design to filter by date using the TODAY() function.
This allows us to avoid changing the filter date every day. In order to get
the information, the report needs to be printed at the end of the day.
Except for actually changing the report date filter every day, is there a
way to have the report use yesterday's date? That way to alter the TODAY
function so the report can be printed the next day instead of the end of the
day.

Thanks,

Jasper

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

------------------------ Yahoo! Groups Sponsor ---------------------~--> Buy
Ink Cartridges or Refill Kits for your HP, Epson, Canon or Lexmark Printer
at MyInks.com. Free s/h on orders $50 or more to the US & Canada.
http://www.c1tracking.com/l.asp?cid=5511
http://us.click.yahoo.com/mOAaAA/3exGAA/qnsNAA/PhFolB/TM
---------------------------------------------------------------------~->

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 · October 6, 2003, 8:55am

Thanks Mike, Patrick

Perfect!

-----Original Message-----
From: Podlin, Michael [mailto:michael.podlin@...]
Sent: Monday, October 06, 2003 8:52 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] TODAY Function

create a calculated field:

yesterday = today() - 1

then have your filter for yesterday.

-----Original Message-----
From: Jasper Recto [mailto:jrecto@...]
Sent: Monday, October 06, 2003 7:49 AM
To: Vantage Groups (E-mail)
Subject: [Vantage] TODAY Function

Good Morning,

I have a report that is design to filter by date using the TODAY() function.
This allows us to avoid changing the filter date every day. In order to get
the information, the report needs to be printed at the end of the day.
Except for actually changing the report date filter every day, is there a
way to have the report use yesterday's date? That way to alter the TODAY
function so the report can be printed the next day instead of the end of the
day.

Thanks,

Jasper

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 · October 6, 2003, 8:55am

Jasper,

One way is to use Today() - 1 in a calculated field.

Daniel C. Spoerl
Estimator/MIS Manager
Toledo Metal Spinning Co.
Phone: (419) 535-5931 ext. 203
Fax: (419) 535-0565
Personal E-fax: (707) 897-1708
Email: dans@...
WebSite: http://www.toledometalspinning.com

-----Original Message-----
From: Jasper Recto [mailto:jrecto@...]
Sent: Monday, October 06, 2003 7:49 AM
To: Vantage Groups (E-mail)
Subject: [Vantage] TODAY Function

Good Morning,

I have a report that is design to filter by date using the TODAY()
function. This allows us to avoid changing the filter date every day.
In order to get the information, the report needs to be printed at the
end of the day. Except for actually changing the report date filter
every day, is there a way to have the report use yesterday's date? That
way to alter the TODAY function so the report can be printed the next
day instead of the end of the day.

Thanks,

Jasper

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

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 · October 6, 2003, 9:07am

Unless you run report on Monday and want Friday's date. Then a few more gyrations are required for TODAY() - 3 option. Holidays we manually override the filter.
-Todd C.

-----Original Message-----
From: Dan C Spoerl [mailto:dans@...]
Sent: Monday, October 06, 2003 7:56 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] TODAY Function

Jasper,

One way is to use Today() - 1 in a calculated field.

Daniel C. Spoerl
Estimator/MIS Manager
Toledo Metal Spinning Co.
Phone: (419) 535-5931 ext. 203
Fax: (419) 535-0565
Personal E-fax: (707) 897-1708
Email: dans@...
WebSite: http://www.toledometalspinning.com

-----Original Message-----
From: Jasper Recto [mailto:jrecto@...]
Sent: Monday, October 06, 2003 7:49 AM
To: Vantage Groups (E-mail)
Subject: [Vantage] TODAY Function

Good Morning,

I have a report that is design to filter by date using the TODAY()
function. This allows us to avoid changing the filter date every day.
In order to get the information, the report needs to be printed at the
end of the day. Except for actually changing the report date filter
every day, is there a way to have the report use yesterday's date? That
way to alter the TODAY function so the report can be printed the next
day instead of the end of the day.

Thanks,

Jasper

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

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/

Yahoo! Groups Sponsor

ADVERTISEMENT
<http://rd.yahoo.com/M=251812.3856299.5103760.1261774/D=egroupweb/S=1705007183:HM/A=1754451/R=0/SIG=11tkldm5d/*http://www.netflix.com/Default?mqso=60178323&partid=3856299> click here
<http://us.adserver.yahoo.com/l?M=251812.3856299.5103760.1261774/D=egroupmail/S=:HM/A=1754451/rand=107029655>

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 the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .

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

system · October 6, 2003, 10:13am

The calculation would be TODAY - 1. I use it all the time.

Shirley Graver
Systems Administrator
Rubber Associates Inc.

-----Original Message-----
From: Jasper Recto [mailto:jrecto@...]
Sent: Monday, October 06, 2003 8:49 AM
To: Vantage Groups (E-mail)
Subject: [Vantage] TODAY Function

Good Morning,

I have a report that is design to filter by date using the TODAY()
function. This allows us to avoid changing the filter date every day.
In order to get the information, the report needs to be printed at the
end of the day. Except for actually changing the report date filter
every day, is there a way to have the report use yesterday's date? That
way to alter the TODAY function so the report can be printed the next
day instead of the end of the day.

Thanks,

Jasper

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

Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/M=251812.3856299.5103760.1261774/D=egroupweb/S=1705
007183:HM/A=1754452/R=0/SIG=11tjeu2hk/*http:/www.netflix.com/Default?mqs
o=60178324&partid=3856299> click here

<http://us.adserver.yahoo.com/l?M=251812.3856299.5103760.1261774/D=egrou
pmail/S=:HM/A=1754452/rand=328616663>

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/.
<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 the Yahoo!
<http://docs.yahoo.com/info/terms/> Terms of Service.

Tracking #: CF8EE88086DE894E8DAA61EEC270BFFC163DB165

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

Topic		Replies	Views
Report Filters Yahoo Archive	2	355	March 4, 2005
Date filter in RB Yahoo Archive	4	333	February 28, 2005
Report Builder Date Calc Yahoo Archive	10	915	October 1, 2003
Day of Week Yahoo Archive	6	525	June 13, 2002
Report builder filter Yahoo Archive	2	346	May 10, 2001

TODAY Function

Related Topics