Hi I would just like to ask if how can I convert these values into date? I think it came from the software they generated. Can you explain how is this possible to convert as a date? I want it to convert as (yyyy-MM-dd) format.
| Date | Period |
| 44013 | July2020 |
| 44015 | July2020 |
| 44041 | July2020 |
Expected Output:
| Date | Expected Date |
| 44013 | 2020-07-01 |
| 44015 | 2020-07-01 |
| 44041 | 2020-07-29 |
Would like to assist me with this one pls thanks.
