MS Access get today date

select Now() as Today_Date;

    Clicky