How to preselect dates when sheet is active?

[#1]

Hi,

I have a problem regarding the preselection of dates when specific sheet is loaded. I am using QV11. I want that all the dates of today and all the consecutive days are selected of my listbox when I access this sheet.
I know that have to access 'Sheet properties' -> 'Add actions' -> 'Select in Field' -> 'Field' and 'Search String'

The specific field is 'date_valid_until'.

I have tried the following 'Search String':  ='>=' & Today()  but then all the dates that start in 2012 and all the following dates are selected. So I am almost there but not quite because it must start today and not from 01-01-2012

I also tried: ='>=' & Date(floor(Today()),'DD-MM-YYYY') but then nothing happens.

Can anybody help?

see attached file: 'activate_dates_sheet.qvw'

Kind regards,

Byron

[#2]

send a qvw file please:)

[#3]

See attachment now.

[#4 · Accepted solution]

firstly change your date format in script from 'YYYY' to 'YYYY-MM-DD'

reload and send qvw again:P

[#5]

That was the problem all along. Thanks for pointing that out.