you can change date format :
Ex : Format(Date, "dddd MMMM dd,yyyy")
every days name and month name will be long type
or you can make procedure to convert :
Private Sub Month_Convertion()
Dim bulan As String
bulan = Month(Date)
Select Case bulan
Case 1
bulan = "Januari"
Case 2
bulan = "Februari"
Case 3
bulan = "Maret"
Case 4
bulan = "April"
Case 5
bulan = "Mei"
Case 6
bulan = "Juni"
Case 7
bulan = "Juli"
Case 8
bulan = "Agustus"
Case 9
bulan = "September"
Case 10
bulan = "Oktober"
Case 11
bulan = "November"
Case 12
bulan = "Desember"
End Select
bln = bulan
End Sub
to call this procedure:
Month_Convertion
lblMonth.Caption = bln
Jery
Best Regards
Reputation Points: 1182
Solved Threads: 393
Posting Sensei
Offline 3,145 posts
since Nov 2007