I have a data set that I'll be updating daily. The original data set is maintained in SQL and updated in near real time. For efficiency, I want to only import the new records, or the delta from the existing .yxdb to the current SQL status. How can I grab a max date from the existing .yxdb and then leverage that as a variable to import transactions after that date from SQL? In all other languages I would simply pass a variable that is defined by start_date = max(df.datefield). I'm at a loss for how to pass this to the input tool. Note: I'm a very new user with experience in Python, R, and other modified scripting languages.
