Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm trying to pass multiple dates to a template app from a selection app using the Load Script. I've encountered an issue where the MATCH function isn't loading the data as expected.
In my Load Script, I'm fetching values from a QVD and using the following WHERE clause:
WHERE Match(JoinDate, $(odag_JoinDate)) This isn't working.
However, when I use the equal operator like this:
JoinDate = $(odag_JoinDate) it works perfectly for a single value.
What could be the solution to make the MATCH function work for multiple dates? Any help would be greatly appreciated!
Solution is :
WHERE Match(Date(JoinDate,'DD/MM/YYYY'), $(odag_JoinDate))
Solution is :
WHERE Match(Date(JoinDate,'DD/MM/YYYY'), $(odag_JoinDate))