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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Crystal Reports - overlapping datetimes
Thank you lbass, you are a genius! Your formula is perfect! Thank you again!- CiviCest
- Post #5
- Forum: Business Objects: Crystal Reports 1 Formulas
-
Crystal Reports - overlapping datetimes
Thank you for the answer. Ive tried those formulas, but theres 1 problem - this formula limits to only 1 row, if i have overlap in more than one row then it doesnt get changed: datetime in - datetime out 12.07.2017 08:00 - 12.07.2017 14:00 12.07.2017 09:00 - 12.07.2017 10:00 - this will get...- CiviCest
- Post #3
- Forum: Business Objects: Crystal Reports 1 Formulas
-
Crystal Reports - overlapping datetimes
I would like to create formula, that finds overlapping times within one date interval for excample: datetime_in - datetime out 11.07.2017 08:00 - 11.07.2017 09:00 11.07.2017 08:20 - 11.07.2017 10:00 11.07.2017 10:10 - 11.07.2017 14:20 11.07.2017 12:00 - 11.07.2017 14:25 12.07.2017...- CiviCest
- Thread
- Replies: 4
- Forum: Business Objects: Crystal Reports 1 Formulas
