Insert Specific date in a column

[Belletmns]

Hi All,

Need your help, from my raw data I need to insert a column with specific dates every month. It is divided into two cycles, every 1st - 15th of the month and 16th - 30 or 31st of the month (depending on how many days the month is).

Here is my raw data:

Here is what I want to achieve: 

EE	Type	No.	Start Date	End date
E1	2105	9	01/09/2020	15/09/2020
E2	2105	9	01/09/2020	15/09/2020
E3	2105	9	01/09/2020	15/09/2020

Is this possible?

Thanks!

[vizAlter · Accepted solution]

Hi @Belletmns — You need to create two new columns through Formula tool:

Start Date:

"01/"+PadLeft(ToString([No.]), 2, "0")+"/"+DateTimeFormat(DateTimeToday(),"%Y")

End Date:

"15/"+PadLeft(ToString([No.]), 2, "0")+"/"+DateTimeFormat(DateTimeToday(),"%Y")

Try attached the workflow to know more about datatypes if you want date fields in String or Date.

If it resolves your query please mark it "Solved" or "Solved" with a Like. This will help other users find the same answer/resolution.  Thank you.