Linking master calender

[raju_salmon]

Hi,

I am new to databases and qlikview, hence seems like basis question.

I have created master calendar using attached script.

In my Sales Table I have date fields in below format. When i am linking this Date field with Calendar Date i can able to link. Is it because of two different formats? What changed i need to do in ca lender script? Any suggestions whether i can modify below database date field or ??

[sunny_talwar]

Your date is actually a timestamp. Either you can change your timestamp to a date -> Date(Floor(_Date)) as Date or you need to create a master Time Table (The Master Time Table) in addition to master calendar.

[raju_salmon]

Hi Sunny,

Date(Floor(_Date)) as Date is not giving me the result. _Date field showing zero records.

[sunny_talwar · Accepted solution]

I guess the _Date field is read as text rather than TimeStamp here. Try this:

Date(Floor(Date#(Left(_Date, 9), 'DD-MMM-YY'))) as _Date