David Perron schrieb:
> Hello Users-
>
> I think I have an interesting question with regards to applying a function
> to date range, I think half of problem solving is explaining it to an
> audience so please, bear with me.
> There is a table Orders that has two DATE columns, StartDate and EndDate.
> The range of dates can vary from 1 week to years. My goal is to get a count
> of days that each row in Orders spans over the current financial quarter.
>
> Example rows and desired result:
>
> OrderId = 1
> StartDate '2008-01-01'
> End Date '2008-06-01'
>
> Days in Q2 = 61
>
> OrderId = 2
> StartDate '2008-03-01'
> EndDate '2008-10-01'
>
> Days in Q2 = 91
>
> Etc.
>
> I can use the TO_DAYS() function to get the absolute count of days
> difference between Start & End, but is there any function that I could apply
> to limit it to return the days between a range of dates.

a snapshot:

MIN(TO_DAYS([date_end]), TO_DAYS([Q_end])) - MAX(TO_DAYS([Q_start]),
TO_DAYS([date_start]))

--
Sebastian Mendel