Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Daylight Savings formula syntax

Hi, I'm working on a formula that will add or subtract minutes based on the daylight savings time.  The formula is defined correctly.

However, when I add it to the report I get an "Error"

=If ((CurrentDate()>=ToDate("03-08";"MM-DD"))And (CurrentDate()<=ToDate("11-01";"MM-DD"));[Age of Incident (minutes)]+240;[Age of Incident (minutes)]+300)

Not what you were looking for? View more on this topic or Ask a question