Date Function

Applies to: Access for Microsoft 365, Access 2019, Access 2016, Access 2013, Access 2010, Access 2007. Returns a Variant (Date) containing the current system date. Syntax Date Remarks To set the system date, use the Date statement. If you use the Date function with a Gregorian calendar, the behavior of Date$ is unchanged by the Calendar property setting. If the calendar is Hijri, Date$ returns a 10-character string of the form mm-dd–yyyy, where mm (01-12), dd (01-30)Continue reading “Date Function”