Date Range

[#1]

Hi,

I have one table to show the validation date for order.

Orders:
load * Inline
[StartDate,EndDate,OrderId
'2010-10-01','2010-12-01',1
'2010-05-01','2010-07-01',2
]

I want to use a table object to show how many valid orders based on month.

For example:

2010-6 1

2010-11 1

How to achieve it without changing the script.

Thanks.

[lironbaram]

hei attach is an example

it changes a little bit the script

but the use of interval match is excatly what you asked for

hope its helps you

[#3]

Sorry, could you paste the scipt directly, we just buy Named call not client version, so I can not open it.

[lironbaram]

orders:

LOAD

OrderId

,

StartDate

,

EndDate

FROM

(

ooxml, embedded labels, table is ??????1)

;

datelist:

load

date(today()-rowno()) as Date

,

year

(today()-rowno()) & '-' & num(month(today()-rowno()),'00') as

MonthYear

autogenerate

3000

;

[lironbaram · Accepted solution]

hei attach is a text file with the script