This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
if it's to generate the dates, refer to @NicholasM post, if it's about the formating, you have to use 2 functions, datetimeparse and then datetimeformat to get the format you want (find a sample workflow attached).
now I understand what you want to achieve, in this case you want to create records.
for that you want to make sure you have a date data type (use the datetime format tool in case your date column is not yet with that data type)
Use the formula tool to calculate the end of the month for each row
then use the generate rows tool where you iníciate the value with the first record of the date column and you increase the value by one day until the date is smaller or equals to las day of month column
have a look into this example. This shows you the configuration of the generate rows tool
here is a sample workflow with the combination of both generate row and the date formating, you first transform the dates into dateformats with a formula, then you use another formula (datetimetrim) to get the first and last of the month and finaly you can use a generate rows to have all the rows for all the possible days in the month.