Common calendar for two Date field in the same table

[#1]

Hi,

Need help on building up a data model  with 2 date fields.        I am looking for an analysis based on Clearing dates & Posting using a common date table        I have attached a file with the data and  the result which I am looking for when I select a month ( for my example its Oct)

Regards,

Rufus Lopes

[johnw]

Attached is an example of trying two date fields in the same table to a common Date field, which is what would then connect to your calendar.  Script below minus the calendar, which would be built like any other calendar.

Data:
LOAD recno() as ID, * INLINE [
CreatedDate, DepartureDate, Value
2011-5-10,2011-5-15,10
2011-5-12,2011-5-15,20
2011-5-15,2011-5-16,40
];

Link:
CROSSTABLE (DateType, Date)
LOAD
ID
,CreatedDate as Created
,DepartureDate as Departure
RESIDENT Data
;