Report Builder - Calculated Date Expression

Yahoo Archive
1
Just add 90 to the date and RB will take care of it. DueDate + 90.
-Todd C.

-----Original Message-----
From: sdzwieg [mailto:sdzwieg@...]
Sent: Wednesday, August 11, 2004 2:38 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Report Builder - Calculated Date Expression



I am drawing a blank on this one.

I want to add 90 days to a due date and have it calculated as a date.
What is the proper expression?

This is my poor interpretation of what I am trying to accomplish.

DAY(DueDate) + DAYS(90) = 99/99/9999


Scott Zwieg
IS Manager
IMS-Electrol
(262) 966-3741 Ext. 230
Fax: (262) 966-7021
szwieg@...





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



Yahoo! Groups Sponsor

ADVERTISEMENT
<http://us.ard.yahoo.com/SIG=129099g32/M=298184.5285298.6392945.3001176/D=groups/S=1705007183:HM/EXP=1092339531/A=2164331/R=0/SIG=11eaelai9/*http://www.netflix.com/Default?mqso=60183351> click here
<http://us.adserver.yahoo.com/l?M=298184.5285298.6392945.3001176/D=groups/S=:HM/A=2164331/rand=115876899>


_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* 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]
2
I am drawing a blank on this one.

I want to add 90 days to a due date and have it calculated as a date.
What is the proper expression?

This is my poor interpretation of what I am trying to accomplish.

DAY(DueDate) + DAYS(90) = 99/99/9999


Scott Zwieg
IS Manager
IMS-Electrol
(262) 966-3741 Ext. 230
Fax: (262) 966-7021
szwieg@...
3
DueDate + 90

is all you need in the calculated expression

-----Original Message-----
From: sdzwieg [mailto:sdzwieg@...]
Sent: Wednesday, August 11, 2004 2:38 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Report Builder - Calculated Date Expression



I am drawing a blank on this one.

I want to add 90 days to a due date and have it calculated as a date.
What is the proper expression?

This is my poor interpretation of what I am trying to accomplish.

DAY(DueDate) + DAYS(90) = 99/99/9999


Scott Zwieg
IS Manager
IMS-Electrol
(262) 966-3741 Ext. 230
Fax: (262) 966-7021
szwieg@...