How to check if data date is end of the quarter

[neoiris]

Hi 

I need to process HR data which comes everyday. 

In the first row of the input file, there is date which is highlighted in yellow.   I need to read this date and check if the date is end of the quarter ( 31 Mar, 30 Jun, 30 Sep , 31 Dec) 

if yes, I need to save the data in different shared drive folder to save end of the quarter data.  Can you please advise how I can achieve this?

To summarize, 

1. how to read the date in the format highlighted in yellow.  (In Input Data, currently I read it from row 3 so this date is ignored) 

2. based on above date, how to check if the date is end of the quarter so that I save it in different folder. 

[geraldo · Accepted solution]

@neoiris 

An example workflow to start resolving your issue
Within the control containers you can build the logic for recording files in their appropriate folders

[Aryasuta_Panda]

Hi , I hope my solution might help you.

Thanks

[neoiris]

Thank you so much. it works!