How to get the first day and last day of the month, by table value

Help Studio
1

Hi to all,
I can get the first day of the month,
and the last day of the month,
starting from the “string” value that identifies the month?
image

For month 02 (varchar in table), first date: 01.02.2021 last date 28.02.2021 ?
Thanks
Aaron

2

Hi @AaronMark

For first date

Date.ParseExact("02", "MM", Nothing).ToString("dd.MM.yyyy")

For last date

Date.ParseExact("02", "MM", Nothing).AddMonths(1).AddDays(-1).ToString("dd.MM.yyyy")