Create new date rows for a specific amount of days using 'generate rows' function

Hello

I'm having trouble trying to generate a new column of consecutive dates for 2254 days forward from a starting date.

As an example starting with date '11-Apr-22', I want to create 2254 new date records increasing from the start date by one day until it reaches date '11-Jun-28'. In excel it would look like this.

I've created a simple workflow attached using the 'Generate Rows' tool but I'm having trouble with my expressions.

I think I'm on the right track on how to go about resolving this problem, but need assistance with maybe the expressions?

Any help would be very much appreciated!

Thanks

Sures

Date query.yxmd

Date Time

Accepted answers

JarekSkudrzyk

@sureslala If your input column is now in date format, the "generate rows" tool config should look like this:

Date query.yxmd

binu_acs

@sureslala I used the DateTimePrase([Date],'%d-%b-%y') format because the given date was in the format dd-mmm-yy, But your original date if the ReportedDate field is in datetime format no need to use the DateTimeParse function. As mentioned like @JarekSkudrzyk you can simply use this field in the generate row tool. I would suggest you to check the metadeta for your fields so that you will have an idea of what needs to be done.

All comments

Matthew

i believe all you need to do is change your condition expression to be "<=" not "="

binu_acs

@sureslala you need to convert the date in datetime format

Date query.yxmd

sureslala

Thanks Binuacs,

I'm getting an error message when I updated my expression in my main workflow 'The value did not change after the Loop Expression'?

Any idea on what I have done wrong?

Thanks

Sures

JarekSkudrzyk

@sureslala I think the date format is causing the issue - you need to amend the format "%d-%b-%y" to suit your input data, which is now yyyy-mm-dd (from what I see in the error message on your printscreen)

JarekSkudrzyk

@sureslala If your input column is now in date format, the "generate rows" tool config should look like this:

Date query.yxmd

binu_acs

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703