Rolling 90 Days Data from Date field

Question

Hi Experts,

I need your help in filtering data for Rolling 90 days data from Date field, which contains text as well as date in the field. I have tried using the filter tool, but i see the results with all the future dates in the field. attached the sample workflow.

could someone please help in getting the desired output.

Thanks

Rolling 90 Days.yxmd

alexnajm · Accepted Answer

You need to convert your Date field into an actual Date!

DatetimeParse([Date],"%d-%b-%Y") >= todate(DateTimeAdd(DateTimeNow(),90,'days'))