Guys, I have a file with data populating from 2018 onwards. It has a date (tran_date) field in '01/01/2018 01:31:23' format. My requirement is to select data only related to a certain month using set analysis.
For example, I need get the list of data related to Jan'21 only. Using 'left(tran_date,10)' I was able to isolate the DD/MM/YYYY but I'm unable to select a date range.