I am trying to load in some data from a database, but only up to and including the previous day (yesterday). The current line in the script to get yesterday's date is:
SetPullDate = Today(Now(1))-1;
This app runs automatically every day at 6:15 AM in QMC and stores the data into a QVD, but each day it does not pull in the correct date for yesterday, but instead pulls in the date for two days ago. So something is not updating correctly here.
When I manually run the QMC job again about 15 minutes later, the data in the QVD is accurate, and the PullDateis indeed equal to yesterday's date.