Output with Month Number and Year

Hi,

I have created Alteryx Workflow as Interface ( Analytic App ). when I execute the WF , its asking Input Path and Output Path as per my design. But is there any way we can get the output with month.No and Year prefix to it automatically based on the Posting date which I am selecting from the Interface. Posting Date is one of the Field in my input.

For ex. If I choose 07/01/2021 to 07/31/2021 as my posting date , my output needs to be \\chennai\newfiles\07_2021_result.

If I choose August means, output needs to be \\chennai\newfiles\08_2021_result ( without deleting other files)

Developer

Accepted answers

All comments

Luke_C

Hi @Karthick461

Here's a simple example of how to parse this information out of the date field to create a file name. You should be able to leverage this in your workflow. Hopefully this gets you in the right direction.

New Workflow6.yxmd

Karthick461

Hi @Luke_C ,

Sorry. I have my Posting date as 07/20/2021 ( MM/DD/YYYY format ) . I modified your formula to achieve , but its still not working.

Since MM/DD/YYYY format is acceptable here , do we have option to get month name and year from this format

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703