Solved change date to other language (1 Viewer)

[Akai90]

hai,

is there any code or format to change my date (dd mmmm yyyy) to malay language without change the region setting on pc ?

my pc is control by domain admin, so everytime i change the region setting to malay it will change back to default value.

so my option is to control the date language in ms access

i only need change date format to malay. example below.

1 january 2022 --> 1 januari 2022
1 june 2022 --> 1 jun 2022

hope u understand

thanks

 

[The_Doc_Man]

The only way I can see to do that is to make a special function for that conversion because Access uses VBA and/or system date management routines. You can't change those either, and the regional settings are almost guaranteed to be system-wide in scope.

The SIMPLEST way I could see to do this is to (a) use the format template of dd-mm-yyyy so that you get numeric strings (b) write a function that, given dd-mm-yyyy input, would use SPLIT to take apart the three segments based on the "-" delimiter (c) create a switch or SELECT CASE statement to convert the month digits into your Malay month names, (d) reassemble the day string, your new Malay month name, and the year string to form the dd-mmmm-yyyy equivalent.

 

[Akai90]

tq for reply

i new in access,

can u please show me simple code for convert data month to malay language

thanks

 

[sonic8]

is there any code or format to change my date (dd mmmm yyyy) to malay language without change the region setting on pc ?

I think, you might be very interested in my text Formatting Date/Time for a specific language and country in Access and VBA.

 

[arnelgp]

using sonic's function, you use:

FormatDateForLocale(Date, "ms", , "d MMMM yyyy")

for the format you showed on post #1

 

[Akai90]

using sonic's function, you use:

FormatDateForLocale(Date, "ms", , "d MMMM yyyy")

for the format you showed on post #1

sonic's function ?
in access ? never heard about sonic function
can you show me example.

 

[CJ_London]

see post #4

 

[arnelgp]

here is the demo.
note that the textbox contains "text" not real date.
so i don't think you can use the function as "formatting" template
for data entry.

 

[Akai90]

I think, you might be very interested in my text Formatting Date/Time for a specific language and country in Access and VBA.

here is the demo.
note that the textbox contains "text" not real date.
so i don't think you can use the function as "formatting" template
for data entry.

my date store in table field.

so what code for that..

Me.Text0 = FormatDateForLocale(Date, "ms", , "dd MMMM yyyy")

this for vba right ?

what the code for convert from table field ? and show on report for more important because on report it will print out.

thanks

 

[arnelgp]

did you see the db i posted. did you Explore the query.
the answer are all there. i think everyone can understand that.

 

[Akai90]

ok already did convert part

thanks for the support