Getting the month from a date and convert it to my own language

questions tips
1

Hi,

I am finding a way to convert the clarion month from english to dutch. The day of the weeks I did by the choose function, in what manner can I do this with month names like october to oktober (dutch)

Thanks!

2

Create a procedure that returns what you need, something like this:

MonthName  PROCEDURE(BYTE pMonth)  !- returns STRING
  CODE
  EXECUTE pMonth
    RETURN '!st month in Dutch'
    RETURN '2nd month in Dutch'
    RETURN '3rd month in Dutch'
and so on 12 times
  END

  RETURN 'Invalid month number'
3

Hi,

I mean with the use of a real month in a date field. I want to return the full dutch date so ‘monday 12 may 2019’ must become ‘maandag 12 mei 2019’

Thanks

4

EasyDotNet has this feature (convert datetime to any culture), for example I choosed “nl” culture in the demo app and see date in Dutch):

image
image795×682 20.2 KB

5

Here is the date time 12.05.2019 20:29:20 (by the way 12.05.2019 is not a Monday)

image
image795×682 19.2 KB

6

What is returned when you use @d17 or @d18 formatting on a date field?

7

Hi I am getting now the english month names. I figured out how to get the week days in Dutch with Weekdag=CHOOSE(Pri:Datum_eerste_les % 7 + 1,‘zondag’,‘maandag’,‘dinsdag’,‘woensdag’,‘donderdag’,‘vrijdag’,‘zaterdag’)

8

Maand = CHOOSE(MONTH(Pri:Datum_eerste_les),‘januari’,‘februari’,‘maart’,‘april’,‘mei’,‘juni’,‘juli’,‘augustus’,‘september’,‘oktober’,‘november’,‘december’)

9

Thanks! That did the trick.. how simple :smiley:

10

I know I’m late, but you have the CLAMON and CLAMONTH…
Look for them on the help and also for LOCALE..