How to change String version to Date version?

[wendyzjy]

input column Date type is String( if use select to change from string to Date, shows Null)

They format of the Date in the input file is yyyy-mm(eg. 2022-02)

How to change the string format to a date format and sort the 12 months of 6 month earlier than current month?(eg, sort out 2020-07 to 2021-06, suppose the current month is 2022-02) ？

[atcodedog05]

Hi @wendyzjy 

You can convert it to date like this. 

Sorry I didn't understand the rest of your requirements.

Hope this helps : )

[wendyzjy]

This looks really smart and so quick! My last question is I want to sort 12 months among all the months, the 12 month ends from 6 months comparing with current month.

suppose current month is 2022-02, i will need below months. Is there a way to make this possible? 

[atcodedog05]

Hi @wendyzjy 

Is this what you are looking for

Hope this helps : )

[wendyzjy]

thank you so much for your prompt reply, actually from the input file, there are hundreds of months, i would like to filter out the specific months with the logic described and delete the rest, any suggestions？

[atcodedog05]

Hi @wendyzjy 

Can you provide some sample input and expected output It will help us get a better understanding of the usecase.

We will be happy to help : )

[wendyzjy]

Absolutly!

I use excel to create a demo:

[atcodedog05 · Accepted solution]

Hi @wendyzjy 

Is this what you are looking for

Hope this helps : )

[wendyzjy]

oh, i thought i got the answer with your workflow attached! Thank you so much!

[atcodedog05]

Happy to help : ) @wendyzjy 

Cheers and have a nice day!