compare dates

I have a date value (very likely a string value that looks like a date) that I would like to compare to current date. I've tried formatting the date and the currentdate() value so I can make comparison. But, i couldn't get the format right. My date value is in this format 8-Oct-2020 (could be a string or number) . I would like to check if the date in my data is greater than current date. If it is then it will be flagged. Also, the data I have is in csv format and it's read into Pipeline Pilot. Will appreciate any advice!