I am attempting to run a Data Flow via a timer e.g. run the Data Flow at 8:00 am every day. I tried doing this using a Custom Expression but I am a bit lost as to how the Executing Time DateTime input should be structured for the Flow to run every day since day/month/year must be specified in a DateTime. Could a wildcard be used for these values? Thanks!
In case anyone is following, I figured it out:
This essentially will create a datetime that will send at 8am either the same or the next day depending on the time. I passed
NOW() which will default the datetime UTC but can pass a specific timezone through that. You can also just pass the timezone of the user’s device through
session.timeZone as well through the
IF( NOW().time.hour > 8, UPDATE_MINUTE( UPDATE_HOUR( ADD_TO_DATETIME( NOW(), 1, "day" ), 7 ), 60 ), UPDATE_MINUTE( UPDATE_HOUR( NOW(), 7 ), 60 ) )