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!
Solved! Go to Solution.
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
[Your Date Field] > DateTimeToday()
if you want it to be specific to the exact time within the current day then can use DateTimeNow().
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
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)
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.
@IraWatt , kindly ignore. I already find the solution. Format should be dd-Mon-yy instead of custom. Thank you so much
No worries ! glad you sorted it @PassION_es :)