There are two SQL scrips I have and they are to be ran depending on what time of day (e.i. 18:00 to 23:59, and 00:00 to 18:00). I have a Table object that can only take one SQL Query for the Data property binding. I’m trying to write an expression for the Property Binding: Root Container.Table as follows:
now = datetime.datetime.now()
if 18 < now.hour <= 23: project.main.SQL_query_1():
where the SQL_query_1() has been defined as a function on the main script.
Thanks for the help!!!