Salesforce Connector LoadDate question...

Fri, 31 Jan 2014 00:33:31 GMT

I am creating a variable named vLoadDate so I can display in a text box the date the data from Salesforce was last loaded. My line is the script is this:

Let vLoadDate = Date(ReloadTime(),'M/D/YYYY');

I ran the report just a few minutes ago, (Jan 30 2014), and the text box is saying the Last Load Date is yesterday, Jan 29. The formula in the text box I'm using is:

='Data Refreshed as of ' & vLoadDate

Any ideas why the date in my text box is not today's date when I just refreshed it 15 minutes ago? Also, the max create date for the opportunities I am pulling is today, 1/24/14 11:42:44PM. So while it appears the max record is correct, the "Load Date" is not.

Thanks in advance for your thoughts.

-Dan

topic Salesforce Connector LoadDate question... in QlikView

Salesforce Connector LoadDate question...