What is the syntax to return the day of a date?

Day(date)
‘returns a value from 1 to 31
‘examples
MsgBox (Day("2056/1/22")) 'returns 22
MsgBox (Day("2056-1-22")) 'returns 22
MsgBox (Day(#1/22/2056#)) 'returns 22

 

 

Advertisements