Count number of days

[raj8257]

I'm trying to count the number of days from the start of the range to a particular date. So for example I want to count the number of days from 01/01/2024 to 31/03/2024 (i.e. 91)

[cpet13]

@raj8257 check out this discussion, I think it will get you what you want. Solved: Identifying Number of Days in a Given Period for E... - Alteryx Community

[binu_acs]

@raj8257 Convert the date into ISO format (yyyy-mm-dd) then apply the DateTimeDiff() function

[raj8257]

This creates another row in the dataset. I don't want to create another row in the dataset. I simply need to count the number of days from the date in the "From" column to the an arbitrary input date which is then shown in the next column. 

[binu_acs]

what is your expected output? are you saying you will have only one row of records? I provided you a sample workflow, you can make use of that in your workflow