Hi,
I'm trying to pass some variables in a workflow. The set-up of the workflow is as follows:
Where the script is
from datetime import date
from datetime import timedelta
import json
today = date.today()
offset = (today.weekday() - 2) % 7
last_wednesday = today - timedelta(days=offset)
d = {'alfredworkflow':
{'variables':
{'last_wednesday': last_wednesday.strftime('%Y-%m-%d')
}
}
}
print json.dumps(d)
And the copy to clipboard part is:
SET @startdate = {var:last_wednesday};
SELECT ...
The issue is the {var:la