Convert day date into number

Hi!

I need help with this please:

I have a a column in a table that shows me the day/month/year. I would like to transform it into a number considering the day of the month:

Example:

How can i do this? i've tried with left function but it doesn't work.

Thanks 🙂