Crystal formula or Command Date Buckets
Posted on 2010-11-22
trying to setup are report using some date fields to create some date buckets
So I have a start date and a end date as fields.
I want to create a command or use formulas(prefer) to calculate the dates between those start and end dates.
bucket 1is enddate - startdate = time duration1 x .025, then add this to startdate
bucket 2 is enddate - startdate = time duration2 x .063 , then add this to startdate
bucket 3 is enddate - startdate = time duration3 x .0125 , then add this to startdate
All Dates are actual numbers and I end up converting them over to dates to view them
Anyone have suggestion on how to do this?