Hi,
I would like to ask your assistance what is the formula to capture or filter future dates in one column?
I do not need the current day and previous dates in my report. Thank you in Advance!
Hey @PassION_es,
Use the datetime tool to convert your string data to datetime data type:
These settings will for for your date format, I used a custom format for the tool config (dd-Mon-yy)
To filter dates which are in the future you can use the filter tool with the following configuration:
ToDate([RowCount]) > DateTimeNow()
It you have any questions make sure to ask
HTH,
Ira
[Your Date Field] > DateTimeToday()
if you want it to be specific to the exact time within the current day then can use DateTimeNow().
Hi @IraWatt & @DataNath,
Your formula works fine however, it did not filter or captured the rows because of the warning error: "not a valid date". Previous datatype is String but it gives me an incorrect number of rows. Then when I change the datatype to Date or DateTime in the Select tool, I got the error invalid date. Please refer to the attached screenshot.
Kindly help me know how to fix this column. It should have a Date datatype. Thanks
Good morning!I am new to Alteryx and I'm trying to begin working on an automated report showing contracts that are expiring within the next two years. I am going to use your formula that you shared, but how to I cap it at two years into the future?
