Hi there,
Just wondering if anyone has built a database task or chain that runs daily that checks if the current date is the accounting period end date? If it is, I want to calculate an average currency rate.
Question
Database Task for Checking Account Period End Date
+1+1For future reference, here’s what I came up with to return the current accounting period end date.
TO_CHAR(accounting_period_api.get_date_until('10', accounting_period_api.get_curr_acc_year('10'), accounting_period_api.get_curr_acc_period('10')), 'MM/DD/YYYY')
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.