In SQL, how to extract date format used for all worksheets?
I want to run a SQL script to extract Date Format used in all worksheets.
Currently, some worksheets are using MM/DD/YY, some ws are using MMM YY.
I want to standardize the date format to MMM YY for all ws. Do you have the SQL script?
FYI, the navigation path to get the date format is Worksheet Time filter --> Advanced button --> Advanced Time Settings window --> Date Format.
Thank you
Regards
Teik Thean