Adding Days

[szeiss]

This seems very simple, but I can't seem to get it to work. I have a Oracle DateTime field called {ECAM_SCHEDULE.EVENT_DATE_TIME}. I'm wanting to pull all records for the next 45 days using the CurrentDate as the starting point. Therefore, I want all records from the current date thru the next 45 days that have a EVENT_DATE_TIME occuring within that time period. Can someone please assist.

Thanks,
Sherry

 

[Mannga]

Try using the DateAdd (, , ) method..

As Far as I can tell if you do something like
DateAdd (dd,45 ,YourDateTime) it should work

HTH
Gavin

 

[dgillz]

Your key is the dateadd function. try this:

Date({ECAM_SCHEDULE.EVENT_DATE_TIME}) in CurrentDate to Dateadd("d",45,CurrentDate)

Software Support for Macola, Crystal Reports and Goldmine
714-348-0964
dgilsdorf@mchsi.com

 

[szeiss]

dgillz, perfect thank you.

Sherry