Date Condition

[Anonymous]

Hello dear community,

Can someone help me to create a condition about the date where date = Today -29days

[petter]

Where should this condition be applied?

- In an expression for a measure?

- For filtering out dates in a date dimension+

- Will it be used in the load script?

- Will it be used in your visualization?

[ecolomer]

You con write:

=date(today()-29,'DD/MM/YYYY')

[Anonymous]

It will be used in the load script

[Anonymous]

[Anonymous]

[Anonymous]

Thank you for your answer but I have this error above in the pictures

[ecolomer]

In the script ...

where Date > date(Today() - 29)

[chinnuchinni]

you can check with your Date field  format, your Date  Field  should be same as your condition date format.

or else you can upload the sample app.

[sasiparupudi1]

Try

define a variable in script

Let vFilterDate=Date(today()-29,'DD/MM/YYYY');

in the where condition, use as below

Date>'$(vFilterDate)'