Works! Thank you, Sunny.
One thing I'm noticing though. Today() is returning yesterday. I've used KPIs and they show the following:
Now()= 11/22/2017 1:51:13 PM
I've checked the date in the PC is right and I've just done a data load. Any reason for Today() to return 11/21?