Good day, everyone.
I working on an app and encountered two issues that I initially thought would be easy to solve. Any help would be greatly appreciated.
Issue #1:
I need to get the number of days difference between two dates it equals 0, 1, 2, 3, and >3. I've tried many different variations of this expression (and others completely different).
=count({<MaxString([ASN Scan Date])-MinString([ASN Scan Date])=0>} Distinct([ASN Number]))
Everything I try seems to get hung up on the Max-Min date part.
Issue #2:
I'm loading hundreds of thousands of records from many tables. To control the amount of data being retrieved, I use this statement:
and rma.row_create_dt > '12-12-31 23:59:00.000'
which works perfect. However, there are many tables and I would like to use a variable in place of the date/time. I use:
Let vstart = '12-12-31 23:59:00.000', then rma.row_create_dt > $(vstart).
The script always stops, saying it doesn't recognize something. What is wrong with the syntax?
Thank you!
