myDate = formatdatetime(now, 2)

The second param passed to formatdatetime is the format setting:

0 =Display a date and/or time. If there is a date part, display it as a short date. If there is a time part, display it as a long time. If present, both parts are displayed.


1 = Display a date using the long date format specified in your computer's regional settings.


2 = Display a date using the short date format specified in your computer's regional settings.


3 = Display a time using the time format specified in your computer's regional settings.

4 = Display a time using the 24-hour format (hh:mm).