This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I am stuck at this place . In my dataset i have 2 columns with year and month --- i need to get the date from these 2 columns.
the day could be the last day of the month .
so if month is 12, my output date will be --- 31/12/2017 and soon.
Please help me with it.
Thanks in advance
this is giving me an error that argument 2 of datetime add is not a number :(
I would suggest:
This assumes year and month are numbers as in your example. If not you can remove the ToStrings
The PadLeft will make it cope with Jan-Sep as well
Finally I chose to use the often overlooked datetimetrim function to get End of Month