Adding to date in 7.0

[gcole]

Can anyone suggest a function or coding to add/subtract 1 day from a date in 7.0. It does not have the DateAdd function.

 

[vidru]

Create a test formula to see if this will work for you:

// @Test
// Add a day to the Current Date
CurrentDate + 1

-dave

 

[gcole]

That adds 24 hours as my date is DateTime.

 

[vidru]

OK, upon further review, I can see the limitations of Date function in CR 7:

http://support.businessobjects.com/communityCS/TechnicalPapers/scr567_datetimefunctions.pdf.asp

Try this:

CDate({Table.YourDateTimeField}) + 1
or
CDate({Table.YourDateTimeField}) - 1

Those should ignore the Time portion of the Date/Time field.

-dave