1
 Follower
2
 Likes

First three letters of a month from a date variable

Builtin & User functions
On our radar
I've seen actions based on switch (12 options) statement to get the first three letters from a date variable.

I use a one-liner.

The DATE-VARIABLE is an input date type and it returns the first three letters of a month (these are in portuguese).

Substr("JanFevMarAbrMaiJunJulAgoSetOutNovDez",(Month(DATE-VARIABLE)*3)-3,3)

Hope it is usefull to somebody.


Created on 15 Jan 2016
Comments (2)
18 Jan 2016
Carl,

This is ment for ideas that OutSystem should build into their platform, not for tips to other OutSystem users :).
2 Mar 2016
Text format would be able to take a date and to this ... 
views
72
Followers
1