Filter and Capture Future date

[PassION_es]

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!

[IraWatt]

Hey @PassION_es,

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

[DataNath]

[Your Date Field] > DateTimeToday()

if you want it to be specific to the exact time within the current day then can use DateTimeNow().

[PassION_es]

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

[IraWatt · Accepted solution]

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)  

[PassION_es]

Hi @IraWatt 

Thankyou. Unfortunately, it only works correctly in the input file. Not in the source data from csv file.  It resulted to null (blank) values in DateTime_out column.

Would you mind to test or use the attached file if it works for you? Thank you.

[PassION_es]

@IraWatt , kindly ignore. I already find the solution.  Format should be dd-Mon-yy instead of custom.  Thank you so much

[IraWatt]

No worries ! glad you sorted it @PassION_es :) 

[Goshawn]

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?