I am not trying to match the date field. we name our RxBatch X1212 the 1212 is our naming convention we use.
The last refresh part is only to get to the MMDD
No really sure how the or where the Let lastrefresh = now();
This report refreshes every 5 minutes.
If we could only pull in RXbatch XMMDD would be great or use it as a filter pane on the sheet would be ok also.
When I run this, it does not load any data.
LET vFilter = 'x' & Date(Today(), 'MMDD');
LIB CONNECT TO 'pharmoresql production (pharmore_rwinkel)';
Where RxBatch = '$(vFilter)';
This is what my data looks like. I am trying to out everything but the #MMDD
So the ones in the red circle should be the only thing being pulled.