Get different parts of timestamp without MID()

[always_confused]

Hello,

I have a spreadsheet with a column containing timestamps (format dd/mm/yyyy hh:mm:ss). I am trying to select certain dates: within a certain month, within a certain year etc. The month I want to select within is selected in a combobox (format yyyy/mm). The way I'm doing it is comparing the combobox value to MID(timestamp_column, 4,7). Which works well enough but it's very slow. I actually have multiple columns of timestamps and they all need to be checked. Is there any built in function do do this? I have seen people using format() but I can't make it work for "mm/yyyy".
In short, my question is: Is there any quicker way to extract different parts of a timestamp value and different combinations of these parts (dd/mm, mm/yyyy etc.)?

 

[arthurbr]

Is your tile stamp real date and time ( right aligned without manual alignment) or text looking like date and time ( formatting is, the underlying values are numbers ( real dates) or text).

 

[always_confused]

Is your tile stamp real date and time ( right aligned without manual alignment) or text looking like date and time ( formatting is, the underlying values are numbers ( real dates) or text).

It's real date and time. The formatting is custom dd/mm/yyyy hh:mm:ss