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

**URL:** <https://clarionhub.com/t/getting-the-month-from-a-date-and-convert-it-to-my-own-language/2856>\
**Category:** questions\
**Tags:** language\
**Created:** [September 25, 2019, 9:34am UTC](https://clarionhub.com/t/getting-the-month-from-a-date-and-convert-it-to-my-own-language/2856 "2019-09-25T09:34:06Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![Jos\_van\_Bragt](https://clarionhub.com/letter_avatar_proxy/v4/letter/j/a8b319/32.png) [@Jos\_van\_Bragt](https://clarionhub.com/u/Jos_van_Bragt)\
**Post date:** [September 25, 2019, 9:34am UTC](https://clarionhub.com/t/getting-the-month-from-a-date-and-convert-it-to-my-own-language/2856/1 "2019-09-25T09:34:06Z")

</div>

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!

---

<div class="post-metadata">

**Author:** ![Mike\_Duglas](https://clarionhub.com/user_avatar/clarionhub.com/mike_duglas/32/1061_2.png) [@Mike\_Duglas](https://clarionhub.com/u/Mike_Duglas)\
**Post date:** [September 25, 2019, 11:03am UTC](https://clarionhub.com/t/getting-the-month-from-a-date-and-convert-it-to-my-own-language/2856/2 "2019-09-25T11:03:00Z")

</div>

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'

```

---

<div class="post-metadata">

**Author:** ![Jos\_van\_Bragt](https://clarionhub.com/letter_avatar_proxy/v4/letter/j/a8b319/32.png) [@Jos\_van\_Bragt](https://clarionhub.com/u/Jos_van_Bragt)\
**Post date:** [September 25, 2019, 3:10pm UTC](https://clarionhub.com/t/getting-the-month-from-a-date-and-convert-it-to-my-own-language/2856/3 "2019-09-25T15:10:13Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Mike\_Duglas](https://clarionhub.com/user_avatar/clarionhub.com/mike_duglas/32/1061_2.png) [@Mike\_Duglas](https://clarionhub.com/u/Mike_Duglas)\
**Post date:** [September 25, 2019, 5:36pm UTC](https://clarionhub.com/t/getting-the-month-from-a-date-and-convert-it-to-my-own-language/2856/4 "2019-09-25T17:36:09Z")

</div>

[EasyDotNet](http://www.ingasoftplus.com/ProductDetail.php?ProductID=301) has this feature (convert datetime to any culture), for example I choosed "nl" culture in the demo app and see date in Dutch):

 ![image](https://clarionhub-uploads.s3.dualstack.eu-north-1.amazonaws.com/original/2X/3/3a396ec79d68e68076bbf8342d550e738ef480ee.png)

---

<div class="post-metadata">

**Author:** ![Mike\_Duglas](https://clarionhub.com/user_avatar/clarionhub.com/mike_duglas/32/1061_2.png) [@Mike\_Duglas](https://clarionhub.com/u/Mike_Duglas)\
**Post date:** [September 25, 2019, 5:44pm UTC](https://clarionhub.com/t/getting-the-month-from-a-date-and-convert-it-to-my-own-language/2856/5 "2019-09-25T17:44:38Z")

</div>

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

 ![image](https://clarionhub-uploads.s3.dualstack.eu-north-1.amazonaws.com/original/2X/8/84c81dcac280889efebab6f07c2fca404ffa2ac3.png)

---

<div class="post-metadata">

**Author:** ![totalhip](https://clarionhub.com/user_avatar/clarionhub.com/totalhip/32/1477_2.png) [@totalhip](https://clarionhub.com/u/totalhip)\
**Post date:** [September 26, 2019, 1:20pm UTC](https://clarionhub.com/t/getting-the-month-from-a-date-and-convert-it-to-my-own-language/2856/6 "2019-09-26T13:20:17Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Jos\_van\_Bragt](https://clarionhub.com/letter_avatar_proxy/v4/letter/j/a8b319/32.png) [@Jos\_van\_Bragt](https://clarionhub.com/u/Jos_van_Bragt)\
**Post date:** [September 26, 2019, 1:33pm UTC](https://clarionhub.com/t/getting-the-month-from-a-date-and-convert-it-to-my-own-language/2856/7 "2019-09-26T13:33:07Z")

</div>

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’)

---

<div class="post-metadata">

**Author:** ![Graham\_Dawson](https://clarionhub.com/user_avatar/clarionhub.com/graham_dawson/32/1331_2.png) [@Graham\_Dawson](https://clarionhub.com/u/Graham_Dawson)\
**Post date:** [September 26, 2019, 9:58pm UTC](https://clarionhub.com/t/getting-the-month-from-a-date-and-convert-it-to-my-own-language/2856/8 "2019-09-26T21:58:19Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Jos\_van\_Bragt](https://clarionhub.com/letter_avatar_proxy/v4/letter/j/a8b319/32.png) [@Jos\_van\_Bragt](https://clarionhub.com/u/Jos_van_Bragt)\
**Post date:** [September 27, 2019, 9:29am UTC](https://clarionhub.com/t/getting-the-month-from-a-date-and-convert-it-to-my-own-language/2856/9 "2019-09-27T09:29:56Z")

</div>

Thanks! That did the trick.. how simple 😃

---

<div class="post-metadata">

**Author:** ![Flavio\_Suarez](https://clarionhub.com/user_avatar/clarionhub.com/flavio_suarez/32/1347_2.png) [@Flavio\_Suarez](https://clarionhub.com/u/Flavio_Suarez)\
**Post date:** [September 30, 2019, 3:12pm UTC](https://clarionhub.com/t/getting-the-month-from-a-date-and-convert-it-to-my-own-language/2856/10 "2019-09-30T15:12:22Z")

</div>

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