day of the week in form

[bipsync]

hi guys..

1st sorry for my english, not that good..

2nd.. i have 2 fields in my form.. on if for date (date picker)..

the other one is for day..


im using this atm:

Private Sub okt_courtdate_AfterUpdate()
okt_courtday = Format(okt_courdate, "dddd")
End Sub

so.. after i pick my date.. when i click tab.. the day field in form will be filled with correct day of that date..

the problem is..

i want to change days to my countries language.. example if it's monday, i want it to be "isnin"..

i need to do this for all 7 days of the week..

can anyone help me with this?

thanx in advance..

 

[CosmaL]

You have to use another field to display date in your language.

Dim okt_courtday_lang as string

Select okt_courtday
case "Monday"
okt_courtday_lang = "isnin"
case "Friday"
okt_courtday_lang = "your language date"
End Select

 

[Galaxiom]

A better way is to create a user defined function to return the name of the day from the day number.

Then it could be used anywhere in the project rather than being specific for a single textbox.