Generate Rows not producing results

[wonka1234]

Hi,

input - 

generate rows tool - 

these are date formats. Where am I going wrong? there is no output for this..

[Luke_C]

Hi @wonka1234 

Assuming the End field is a date format you shouldn't need the datetimeparse, but if not, then you need to have the syntax of %Y-%m-%d.

Otherwise it should work

[FinnCharlton]

Hi @wonka1234 , your datetimeparse function doesn't look quite right, this format is written '%Y-%m-%d'. However, because your dates are already in the default Alteryx format, you should just be able to write Date < End in your Condition Expression.

Hope this helps!

[ChrisTX]

This part is wrong

End should be [End] and the specifiers are not right for DateTimeParse.  Each specifier is only two characters long, like %Y

See this page: https://help.alteryx.com/20223/designer/datetime-functions

Chris

[binuacs]

@wonka1234 Your Start and End fields are already in the Date format then , no need to use the DateTimeParse function