Creating Dates with Values

[i_kafali]

Hi all,

I have columns as below;

Years and months coming from dateset in number format. What i want to do is to create date out of this numbers. 

Dates has to be last dayof the period 

For instance 2018 and 6 should be 30.06.2018 and 2019 and 3 should be 31.03.2019 and so on. 

Thanks in advance

YEAR	MONTH
2018	6
2018	7
2018	8
2018	9
2018	10
2018	11
2018	12
2019	1
2019	2
2019	3

[AndreyBear · Accepted solution]

eomonth(date([year],[month],1),0)

[i_kafali]

Thank you it works 🙂