Convert day date into number

[Migscruz]

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:

Date	Number
26/11/2021	26
27/11/2021	27
28/11/2021	28
29/11/2021	29
30/11/2021	30
1/12/2021	1
2/12/2021	2
3/12/2021	3
4/12/2021	4

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

Thanks 🙂

[rsbin · Accepted solution]

@Migscruz,

Try:

DayofMonth = Day[Date]

Regards,