Mapping of closing stock info based on date

[AnanditaShankar]

Hi. I want to map 'Stocks Opening Qty' and 'Stocks Closing Qty' based on 'Posting Date" and 'Fiscal Year/Period". Due to diff date format I'm not able to do so

[SGolnik]

It looks like Fiscal Year/Period is by month and date. I would parse out the date column in Posting Date using regex or a formula tool to extract the month and year. Then you will be able to join the data on it.

[AnanditaShankar]

Tried parsing. Didn't work

[cjaneczko]

You can use a DateTime tool to normalize the dates. For your first tab you'll want to use the Custom format as shown in the screenshot below. Then you will do the same for the Closing Stock tab but use a new custom format in the code here.

MM.yyyy

It will add a new DateTime field to the end of your data that you can use to match up with the other tab.

[AnanditaShankar]

And if I want to split 2023-02-01 to 2023-02 how do I do that ? Below is not working 

[MilindG · Accepted solution]

@AnanditaShankar 

[cjaneczko]

I would take a look at this help documentation based on how you want to display it.

https://help.alteryx.com/20223/designer/datetime-functions#:~:text=Alteryx%20uses%20the%20ISO%20form....

But you can use a formula tool

DateTimeFormat([DateTime_Out],'%Y-%m')

[AnanditaShankar]

@MilindG  Thanks so much. It works