Calendar problem with snowflake datamodel

[Anonymous]

Hello

I have the following problem:

Im using a calender in different reports. Today I was trying to use it anew, but it doesnt work. Im using a smowflake datamodel:

When I make selection on Datum Reklamation from rm_main the data gets filtered and I see also that the selection options on Calendar.CalDate get smaller. But then when I select additionally all selectable values from Calandar.CalDate no values are shown.

Pretty frustratig it is

Thx for your help.

cheers chesterluck

[Anonymous · Accepted solution]

Got it

me stupid didn't look at the format. Datum Reklamation was a timestamp shown as date. Had to use MakeDate function to get it right.

P.S: I love to solve my own posts

cheers