Show data from 45 days and over ago

[khaycock]

I know this seems quite basic but can't get my head around getting a button to show all data that is dated from 45 days and over ago.

I have the variable vMinus45days=Date(Today()-45,'DD/MMM/YYYY') set up but can't figure out how to get the data that is older than 45 days to show too.

Any ideas?

[Aurelien_Martinez · Accepted solution]

Hi,

In your button properties->actions->add->Selection->select infield

on Field -> yourFieldDate

on search string -> ='>=$(vMinus45days)'

(FYI my variable is -> vMinus45days = =Date(Today()-45,'DD/MM/YYYY'))

Aurélien

[#3]

I agree with amartinez35

But bear in mind one thing that is when you load the data you have to make sure that the underneath data is loaded as a date not a string that looks like a date. Otherwise, it won't be comparable.

[khaycock]

Doesn't do anything

Not sure if the formatting of my date makes a difference?

[khaycock]

Yeah I think that might be my problem

[Anonymous]

Share sample data, so we can help you with the format of data you have.

[Aurelien_Martinez]

My button :

My variable :

[khaycock]

Yeah I have exactly the same stuff but the data isnt changing. I'm thinking it is something to do with date formats maybe but not sure why that would make a difference?

[Aurelien_Martinez]

Can you join your .qvw file ?