Select in field, date between and null values

[#1]

Hi All,

I have problem with Select in field. Now my results shows only values that are between my search.

I have NULL values in 'Enddate' field. They all have 'Startdate'. So what I am missing is to have also those dates that don't have Enddate, but have Startdate. Startdate should be  <  vDatedEnd.

I have named all NULL values to 'Toistaiseksi'.

        vDatedStart                       vDatedEnd

Now I have two 'Select in Field' Action in search tab.

1.

2.

Is there any solution to do this?

I will be thankful for any help!

-Marko

[sunny_talwar]

Would you be able to share your application where you are testing all this?

[#3]

Hi Sunny,

I'm sorry, that is not possible. There is too much private information.

-Marko

[sunny_talwar]

Have you looked at this thread?

Preparing examples for Upload - Reduction and Data Scrambling

[#5]

Thank you for that link.

I added that application in my earlier post

-Marko

[#6]

Hi,

Is there any solution?

Regards,

Marko

[Anonymous]

Marko,

Just a thought can you input some infinite date in the end date if there is null value. if the start date reaches the infinite date increment the end date year by 10 years. Hopefully that should solve your problem.

[sunny_talwar]

I was unable to get this to work, may be swuehl‌ can offer his expert advice.

Best,

Sunny

[boorgura]

Try using this expression as search string in the EndDate action

='(">=$(-date($(vDatedStart)))"|"Toistaiseksi")'

[vinieme12]

Hi,

Please find attached qvw for reference, hope it helps

Cheers

V