Show All

Specify dates in dual calendar databases

• Do one of the following:

  • To convert to Buddhist calendar dates when the regional settings in Microsoft Windows Control Panel are set to the Gregorian calendar, type the letters B or b in front of the year entry in a date format— for example, to enter the Buddhist date 1/1/42 (or January 1, B.E. 2542), type 1/1/b42 and Microsoft Access displays its Gregorian equivalent, 1/1/1999.

  • To convert Gregorian calendar dates when the regional settings in Windows Control Panel are set to the Buddhist calendar, type the letters G or g in front of the year entry in a date format.

  Note  This technique applies only when you are using a date as criteria in a query.