I have a migration script, which runs a query and outputs a csv file based on criteria in the screen shot below.
It is being run manually at the moment, with the pay_date updated each time.
What can i put in the where clause that would be where company = ‘ABC’ and the pay_date = TODAY?
I will then schedule this to run on a daily basis to output the days ledger activity