linking dates problem

[#1]

Hello,

i'm trying to develop a calendar like this oneLinking to two or more dates

but i can't understand why my data doesn't apply the month correctly, it gets null on the feb month,

in this dataset contains the process, create date, completed date and status. I'm following the steps in the link but i can't understand what is wrong.

Please see the attached file.

[whiteline]

Hi.

You don't have any records for Feb dates in your DateLink table.

You should have all kinds of dates there, not only create Dates.

Concatenate the rest ones.

[#3]

As you can see in the link tab i do have the COMPLETED_CALENDAR and the CREATE_CALENDAR concatenated to build the DateLink, and there are feb records. I'm i doing it wrong?

[Anonymous]

Something's wrong with the calendar.  You have each date multiple times, and most of the dates are not associated with months and years.

Try to create table box with calendar fields, you'll see.

[#5]

i know, and don't know caused this 

[Gysbert_Wassenaar]

Something is wrong with the subroutine you use to create the calendar. Try this instead on your last script tab:

DROP TABLE TMP;

//CALL CalendarFromField('Date', 'CommonCalendar', '');

Calendar:

Load Date, Year(Date) as Year, Month(Date) as Month, day(Date) as Day, weekday(Date) as Weekday

resident DateLink;

[#7 · Accepted solution]

This comment gave me a light, the problem was in the SQL statement, on the conversion from datetime to date. Thank you all!

[#8]

the subroutine is ok! thanks!

[Anonymous]

You have a problem with Date in the DateLink table - it is timestamp

Use
floor(CREATE) as Date

floor(COMPLETED) as Date

There is something else besides this...

[Anonymous]

Edit - no, that's it I guess