I want my user to select the "from date" and "to date", and i should be able to set the minimum date and maximum date limits. Is it possible in Alteryx?
Don't think there is a way to limit it within the tool, but you can add an Error Message tool to check that the date selected is between specific dates... that way if someone picks something outside those parameters, they will receive a warning letting them know which dates should be selected between (i.e. you can create the error message telling them the date parameters)?
NJ
are you looking for a past date only?
If this is true, then display error message, that's the expression that will cause the error to display.
Also, the input date is likely a DATE, while the datetimenow() needs to be formatted as %Y-%m-%d. Otherwise, you might have a problem.
[#1] < DateTimeFormat(DateTimeNow(),"%Y-%m-%d")
Cheers,
Mark
As @NicoleJohnson described, you can use the Error Message Tool to establish the limits for dates.
