indonesian_date(date)
Rate this function: Average rating: 1.7 (3 votes) Discuss this Custom Function
Andrew, Gbi wtc serpong
http://gbiwtcserpong
Indonesian Date Format
Sample Input:
| indonesian_date(Date(14;14;2012)) |
|
Sample Output:
|
Description:
Facilitate the writing of the date format according to Indonesian style
Note: these functions are not guaranteed
or supported by BrianDunning.com. Please contact the individual
developer with any questions or problems.
This is my Custom Function and I want to
edit it
Discuss:Make a comment about this Custom Function (please try to keep it brief & to the point). Anyone can post:
|
Newest Custom Functions:
| 1. |
list.intersect (listA; listB) |
| |
(Mon, May 14, 12:43pm) |
| 2. |
WeekStart ( weekOfYear ; year ) |
| |
(Sat, May 12, 8:42am) |
| 3. |
PercentToWords (FIELD) |
| |
(Thu, May 10, 3:16pm) |
| 4. |
PercentToText (FIELD) |
| |
(Thu, May 10, 2:37pm) |
| 5. |
StripReserved( text ) |
| |
(Wed, May 02, 6:05pm) |
| 6. |
ListBaseTables |
| |
(Wed, May 02, 3:48pm) |
| 7. |
ValidEmail( theEmail ) |
| |
(Wed, May 02, 7:27am) |
| 8. |
UltraDate (Text; LongDate_or_DateDigit) |
| |
(Wed, May 02, 6:07am) |
 |
|
Your Case statement could be expressed more easily with a Choose function. So your CF becomes:
Let (
mo = Choose (Month(date);"";"Januari";"Februari";"Ma ret";"April";"Mei";"Juni";"Juli&quo t;;"Agustus";"September";"Oktober";"Nove mber";"Desember")
;
Day(date) & " " & mo & " " & Year (date)
)
David, Sydney
February 06, 2012 10:56pm