Forum Discussion
i_kafali
7 years agoHelper II
Creating Dates with Values
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 |
eomonth(date([year],[month],1),0)
2 Replies
- AndreyBearAdvocate II
eomonth(date([year],[month],1),0)
- i_kafaliHelper II
Thank you it works :)