Help Writing a formula to update a Date Column

[aogle3497]

I have the following column in my upload file and would like to create a formula that would update this column when the date has passed to be the following Tuesday of the next week since our payment date occurs on Tuesdays. Having this formula be reoccurring so when I run the workflow the following week it would then change the date to be the next Tuesday and so on would be great! Any help or ideas would be greatly appreciated!

Payment Date
06062023
06062023
06062023
06062023
06062023
06062023
06062023

[binuacs]

@aogle3497 try the below formula

DateTimeFormat(DateTimeAdd(DateTimeParse([PaymentDate],’%m%d%Y’),7,’day’),”%m%d%Y”)

[aogle3497]

I'm getting a malformed function call (expression #1) error for that formula

[binuacs · Accepted solution]

@aogle3497 try now

DateTimeFormat(DateTimeAdd(DateTimeParse([PaymentDate],'%m%d%Y'),7,'day'),'%m%d%Y')

[aogle3497]

That worked thanks!