Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
;