We’ve just got hold of TDA 2.7 which is proving to be a great piece of kit! I’m slowly finding my way around it, but I’m stuck on the automation side of things where variables are concerned.
I am running the attached query weekly and would like to automate it.
I have two blind variables :fromdate and :todate in the query, which come up as TIMESTAMP variables when running the query manually. The query is run weekly with 4 different date periods
first of month current date
This financial yr(01-04-2010) current date
first of month (previous yr) current date (previous yr)
previous financial yr current date (previous yr)
I’ve attempted to add the variables option in the Automate section and have tried various options to generate the dates required (either by building an expression or a seperate sql, but I can’t seem to get the format right.
I think it might be due to matching the formats of the date?
Can anyone point me in the right direction please??
Thanks in advance