Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
= '>=' & Date(Today()) & '<=' & Date('1900-01-01')
works perfectly.
Thank you Junior Junior and G 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) )'
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!
= '>=' & Date(Today()) & '<=' & Date('1900-01-01')
works perfectly.
Thank you Junior Junior and G Wassenaar