Counting days in a row

[Kjaer]

Hi

I have this column of dates (in this format) and want to calculate the days starting from 01-01-2021 and ending 31-12-2021.

Can anyone help me?

Regards 

Kjaer

[apathetichell]

your dates fed in as dates on my machine so I didn't have to do any conversions - assuming this is true in your workflow - use multi-row formula configured as pictured.

[binuacs]

@Kjaer , similar approach like @apathetichell , just added the DateTimeParse method 

[Kjaer]

@binuacs 

Thanks for the solutions. In this case my input is a tabel from excel like the one I posted. That means that I have to make a change in the date format before it works. I have tried but no. Can you help me.

[Qiu]

@Kjaer 
It works just in my test.
The alteryx imported the data in Date Format.
Can you show your example?

[atcodedog05]

Hi @Kjaer 

If the dates in excel are in date datatype (like below) Alteryx will automatically take it as a date.

If still, you are facing the issue here is a modified version of @binuacs workflow which should handle the dateformat. Change the date to the input format to get them parsed here date format is %d-%m-%Y. Refer to this page for more info https://help.alteryx.com/20213/designer/datetime-functions

Workflow:

Hope this helps : )

[Kjaer]

@atcodedog05 

It doesn´t work for me. Now I have posted my excel file and the alteryx-file. I just get null in the new column.

[atcodedog05 · Accepted solution]

Hi @Kjaer 

Try this

Workflow:

Hope this helps : )

[Kjaer]

@atcodedog05 

Now it works. Thank you :-)))

[atcodedog05]

Excel dates were treated as Alteryx dates too 🙂

Happy to help : ) @Kjaer 

Cheers and have a nice day!