Insert Specific date in a column

Question

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:

EETypeNo.Start DateEnd dateE12105901/09/202015/09/2020E22105901/09/202015/09/2020E32105901/09/202015/09/2020

Is this possible?

Thanks!

vizAlter · Accepted Answer

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.