Tax Payment Due Date - Next Thursday after Payroll Date

[danielw.au]

Hi All,

I have a database where we store payroll values. Against each payroll, we record the PayrollPaymentDate. This is the date in which the payroll was paid to employees.

I need to generate a due date for our taxes. This is always the first thursday the week after the PayrollPaymentDate.

As an example, if the PayrollPaymentDate is 16th May 2014, then the tax is due on Thursday 22nd May. If the PayrollPaymentDate is the 14th May, then the tax is due on Thursday 22nd May.

I'm not sure how to create an expression to calculate the date so i can display this in reports and forms.

Thank you in advance.

Daniel

 

[plog]

This should be more than an expression, I would use a function. You would pass the function a date and it would return the data of the first Thursday that is a week after the date you past it.

You would use the Weekday function (http://www.techonthenet.com/access/functions/date/weekday.php) to determine the day of the week you were passed. Then passed on that you could determine how many days to add (Wednesday=+8, Thursday= +7, Friday=+13, etc.) Once you have that number you can use the DateAdd function (http://www.techonthenet.com/access/functions/date/dateadd.php) to get the specific date.

Give it a shot then post back here if you have any issues.