Adding a calendar or a date filter

[juliakhaa]

Hello to the whole community. 
I can’t cope with the following problem. My table has a large array of data and for faster loading and convenience I want to make a calendar or filter by date.

The date has the following format: 18.11.2022, 16.06. When adding a date to the filter without time, accordingly, a bunch of repetitions appear, but distinct doesn’t work with dates. What can you advise?

thank you

ps. vizlib calendar doesn’t work with my field either 

[Mauritz_SA · Accepted solution]

Hi Julia

Try this on your filter:

=Date(FLOOR(Date#(Date,'DD.MM.YYYY, HH.mm')),'DD.MM.YYYY')

Good luck.

Mauritz

[Vegar]

A date is represented numerical by an integer, a timestamp (as in your case) also has a decimal representing the time of day.

You need to have the same values in your master calendar as you have in the key field of your transaction  data.

I see two possible solutions.

1. create a true date fvalue in your transaction data. Try using floor(date)  or dayname(date). Create your master calendar as you do today but link it to your new field. 

2. Create a calendar based on your current [date] valued  This means that you might have one row per timestamp in your master calendar. You might have more than one row per date, but that is not necessarily  a problem.

[juliakhaa]

Hi)

returns an error in the expression

but this one helped me, thank you!

date(floor(mydate), "DD.MM.YYYY")