Result = Day ( Date AS Date ) AS Integer
Returns the day component of a Date value in the local timezone.
PRINT Now; " -> "; Day(Now)
05/16/2002 22:31:30 -> 16
Date & Time Functions