topic Re: Using VStart date with a expression field in QlikView

Using VStart date with a expression field

tsoley9262 — Tue, 07 Jan 2020 20:18:26 GMT

I am using a VStart date and VEnd date in my app to search on a specific field, I was asked to change the field I am searching on to this Expression if(Disposition = 'Migration + Clean-up' , [Clean_Up_Date], [Scheduled_Migration_Date]) ... now my date variables are not working any help would be appreciated

Re: Using VStart date with a expression field

Rodj — Tue, 07 Jan 2020 20:39:25 GMT

Can you tell us what the old expression was and what you search expression is? That might give us a hint so we can assist you, at the moment you haven't told us enough.

Re: Using VStart date with a expression field

tsoley9262 — Tue, 07 Jan 2020 20:42:22 GMT

Current expression is =Min({1}Scheduled_Migration_Date)

Re: Using VStart date with a expression field

Rodj — Tue, 07 Jan 2020 20:46:58 GMT

And your search expression? What result did you get before and what do you get now?

Does the other date field have the same format as Scheduled_Migration_Date? I'm guessing, but perhaps the search isn't working because the date format is different.