Custom Date Field based on Payroll date

Asimkz157

Hello all, I have a report that takes payroll statements from an excel file and emails them to each individual employee.  Would there be a way to add in a date field that would use a payroll date, the date the employee would get paid on.  For example, right before the email is sent I have a formula tool that creates a SUBJECT field which states 'Attached is your July's statement for payroll 9/3/2021'.  

Currently I have to manually update the month name and the date based on when will the employee will get their check.  The pay period is bi-weekly.  Wanted to see if there was any way to automate this. 

Thank you in advance.  

phottovy

Hi @Asimkz157 ,

If you have both the statement and payroll dates as fields in your data set, you can use a formula to update the subject:

"Attached is your " + DateTimeFormat([Statement Date], '%B') +"'s statement for payroll " + DateTimeFormat([Payroll Date], '%m/%d/%Y')

Formula tool:

Output:

If you are using the email tool in Alteryx, you can then select the calculated field to be the subject of your email