embededed macro "Date() function" returns 12/30/1899 not system date

[MSG56]

I have a simple embedded macro for a button that I want to use to update a date field to todays date, but everytime I click the button it returns 12/30/1899. I understand that is the date for "0", but I was expecting Date() to return the system date/today's date. My macro looks like this:

SetValue
Item = [Last Time Made]


Expression = [Last Time Made] = Date()

[June7]

Try changing the Expression to simply: Date()

[MSG56]

Thank you! That solved my problem and now that I look at it it seems obvious.