set analysis or operator

[#1]

Ive created a button and want it to select all dates larger than 'Date' OR 'Date'=1900-01-01

The code ive got is:

='>=$(=date(today())) OR =$(=date(1900-01-01))'

but it doesnt work.

The first part of the code, ie ='>=$(=date(today())), is working and selects all dates larger than today but the second part does not work.

How do i do to solve this?

Thanks!

[Gysbert_Wassenaar]

Try ='(>=$(=date(today())) | 2 )'

date(1900-01-01) is date(1898) is somewhere in 1905. num(date#('1900-01-01','YYYY-MM-DD')) = 2. You could use a variable for that:

vOrDate =  num(date#('1900-01-01','YYYY-MM-DD'))

and as search string ='(>=$(=date(today())) | $(vOrDate) )'

[offjunior]

Good afternoon friend!

See if that helps you. If you do not help, send me a document qvw with an example of what you are needing.

= '>=' & Date(Today(), 'DD-MM-YYYY') & '<=' & Date('1900-01-01', 'DD-MM-YYYY')

Following is a document attached to qvw you see in practice.

HUG!

[#4 · Accepted solution]

= '>=' & Date(Today()) & '<=' & Date('1900-01-01')

works perfectly.

Thank you Junior Junior and G Wassenaar