How to change day in a date to starting day.

421 Views Last edit Feb 21, 2022 at 06:53 AM 2 rev

Hello,

The date format is 20220912 needs to be changed to 01.09.2022.

Example - giving the input value 20220912 and the output has to be 01.09.2022, so here I need to change the day to first day.

So for, 20210823 to 01.08.2021.

How to append and concatenate?

How to write code for this? Please help me.

Thanks in advance.