Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
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
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.
Doesn't do anything
Not sure if the formatting of my date makes a difference?
Yeah I think that might be my problem
Share sample data, so we can help you with the format of data you have.
My button :
My variable :
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?
Can you join your .qvw file ?