I have a list of sales with order_date (format dd:mm:yyyy hh:mm). I would like to filter them by month. Any suggestions how can I do that in a simple way? I am not able to write complex script at the moment.
Thanks! This was very useful. Do you have a list of all/similar functions to Month which I can use? For example it could be very useful for me to check also quarters or day of the week when orders happen. Perhaps there are functions ready for this