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 Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Date Formula Question
Ok, I'll try it out tomorrow. Thank you for all of your help.- iamkaos
- Post #5
- Forum: Business Objects: Crystal Reports 1 Formulas
-
Date Formula Question
It is a date time field. The Department's start time is 11:00PM. So for the instance of "Yesterday", I would use: Case "Yesterday" if dateadd("h",-7,datetime(dtstodate({table.datestring}),timevalue({table.timestring))) = Currentdate -1 then formula = 1 else formula = 0 ?? If so...- iamkaos
- Post #3
- Forum: Business Objects: Crystal Reports 1 Formulas
-
Date Formula Question
I'm trying to create a selection date formula for a specific department that operates from 11:00PM to 7:00AM. i currently have this selection formula: select case {?Relative Date} case "None" if DTSToDate ({table.date}) in {?StartDate} to {EndDate} Then formula = 1...- iamkaos
- Thread
- Replies: 4
- Forum: Business Objects: Crystal Reports 1 Formulas
