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

[MarqueeCrew]

@MaxSchG ,

left([_current field_],8) + "28"

 that should work!

 Cheers,

 mark

[MaxSchG]

@MarqueeCrew Hey Mark, thanks for your quick response. In which tool should I implement it?

Thanks, Max

[atcodedog05]

Hi @MaxSchG 

Its a formula for MultiFiled formula tool https://help.alteryx.com/current/designer/multi-field-formula-tool

[MaxSchG]

@atcodedog05 Thanks for your answer. Could you provide me the adjusted Workflow? That would be awesome!!

[MarqueeCrew]

Yes!  Use a multi-field formula tool.  One stop updating.  

note however, if sometimes the date is not present, you'll need something like:

IIF(!Isempty([_current field_], left...., "")

 cheers,

 mark

[atcodedog05 · Accepted solution]

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 😀👍

[atcodedog05]

Happy to help 🙂 @MaxSchG 

Cheers and Happy Analyzing 😀