Date format name month to number

[cmano]

Hello guys.

I have date like 1/2/2022, 1/3/2022

I inserted at script the below

Month([Ημ/νια Red Card]) as Month,

Day([Ημ/νια Red Card]) as Day

but at month list box i have the below : 

How i can convert the months to numbers  (1,2,3) etc?

thank you.

[Or · Accepted solution]

Num(Month([Ημ/νια Red Card])) as MonthNum