does anybody know how to automatically convert the shortdate format of the date settings in the control panel-regional settings to long date format?
does anybody know how to automatically convert the shortdate format of the date settings in the control panel-regional settings to long date format?
do you mean format the output of the date() function to the system long date format?
if so,
Format(Date, "Long Date")