Limit data using expression with Date

[Laura Rojas]

Hi all!

I have a doubt. I have to do a limit data expression for all graphics with this logic:

All the grapichs must show only the data after this date 6/11/2020 but i dont how to do it...

I think something like this: [month]>10 and [year]>="2020" ... but I don't have the day in a separate field..

I hope you help me with this :)

[Shrutika Aggarwal]

Assuming there isa column [A] containing date as 6/11/2020.

Then you can use the following expression to limit data:

Day([A])=06 And Month([A])=11 And Year([A])=2020

[Fabian Duerr]

If only want to filter the data in certain visualizations you couldalso create a filtering scheme with your desired settings and then apply it to your visualizations.

When you go with the data limiting expression, make sure that the format of your column is really DATE not STRING