Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Derived field based on subtracting 2 dates and if 0 add 1
Derived Field value based on subtracting to dates and if the value is zero then return a 1 else return the value from subtracting the two dates. Code : Sub DateDiff() If "FAX_DATE" - "INPUTDATE" = 0 Then DerivedField(1) Else DerivedField(("FAX_DATE") - ("INPUTDATE")) End If End ERROR is...- lazy2k
- Thread
- Replies: 2
- Forum: Strategic Reporting Systems(SRS): ReportSmith
