Output a specific date

MaxSchG

Dear all, 

I would like define the 28th of each month as a specific date (each date of the column "monat" should end with 28 // ex. 2020-10-28)  that is written into my date formular so to say. Are there any ways how to adapt such an adjustment to the follwing workflow? Please find Workflow, Input and Output data attached. 

Thanks for your help in advance. 

Best, 

Max

WF add up.yxmd

Output add up.xlsx

Input add up.xlsx

atcodedog05

Hi @MaxSchG 

I looked into your workflow. Basically you want to convert any date in column Monat to 28th of the month.

Formula

left([Monat],8) + "28"

Output:

I have added the formula in the last formula tool. Which had import date.

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

WF add up.yxmd