indonesian_date ( date )

Indonesian Date Format

Average rating: 4.3 (30 votes) Log in to vote

Andrew - Show more from this author

Sample input:

indonesian_date(Date(14;14;2012))

Sample output:

14 Februari 2012

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

Let
([bln=
Case(
Month(tgl)=1;"Januari";
Month(tgl)=2;"Februari";
Month(tgl)=3;"Maret";
Month(tgl)=4;"April";
Month(tgl)=5;"Mei";
Month(tgl)=6;"Juni";
Month(tgl)=7;"Juli";
Month(tgl)=8;"Agustus";
Month(tgl)=9;"September";
Month(tgl)=10;"Oktober";
Month(tgl)=11;"November";"Desember")];Day(tgl)&" "&bln&" "&Year(tgl))

Facilitate the writing of the date format according to Indonesian style

Comments

		David Feb 6, 2012
Your Case statement could be expressed more easily with a Choose function. So your CF becomes: Let ( mo = Choose (Month(date);"";"Januari";"Februari";"Maret";"April";"Mei";"Juni";"Juli";"Agustus";"September";"Oktober";"November";"Desember") ; Day(date) & " " & mo & " " & Year (date) )

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

indonesian_date ( date )

Comments

Support this website.

Support this website.