Generate Dates per row of the current month

[Grail030510]

Hello Everyone,

I would like to ask for help regarding how I can generate each row a date from the current month

for Example:

It will detect the current month and generate a row with dates starting from day 1 to end of the month

Ex:     the month is January on the system clock

Output

1/1/2024

1/2/2024

1/3/2024

1/4/2024

1/5/2024

.......

1/31/2024

Thank you

[alexnajm · Accepted solution]

Try this out - I used a DateTimeNow tool since I didn't know what data you need but this will get the process done even if you don't have data!

[aatalai]

Try the TS filler tool setting the start date and end date of the month

[Raj]

Use @Grail030510 
1-DateTimeFirstOfMonth()  to get first date

2-DateTimeLastOfMonth() to get last date

3- Generate row formula to get all the dates between.

this will be dynamic to every month and every year.

[alexnajm]

@Raj I am not sure the multi row formula will generate all rows in between - that's why I think my solution works well. If you could show the multi row formula option, I'd love to see it!

[Raj]

@alexnajm my bad i wanted to write generate rows.

[Raj]

Sol attached.

[cjaneczko]

You can use Generate rows to do this. Since this tool has a Gray input anchor you do not need to connect this to any other tools prior to it. It can generate the rows without prior data. You can use this to feed the rest of your workflow.

[aatalai]

@Grail030510 here it is with the TS filler tool