Dynamics Community Forum Thread Details

change month language to spanish

hi does anyone know how to do this? i've tried everything and have figured out how to do it yet i tried using calculated fields, the user date, document dates...

Hi Roberto

It will take a few calculated (5) fields but it can be achieved.

You will need to split the date into Day, Month and Year. You can use the DAY, MONTH, YEAR system-Defined functions to get these.

Infact, as we will need the Day and Year as strings you could use RW_DateToString() user defined function (system series) instead, parameters and format symbols below:

in date IN_Date;
in string IN_Format;

Format Syntax:-
ddd = day of week as 3 letters
dddd = day of week in full
N  = day of year
NN  = day of year (padded)
D   = day of month
DD   = day of month (padded)
M   = month of year
MM   = month of year (padded)
mmm  = month of year as 3 letters
mmmm = month of year in full
YY   = year of date (2 digits)
YYYY = year of date (4 digits)

You could use "DD-" and "-YYYY" as your format strings.

Once you have the Month as an integer (using MONTH), you can use RW_Token() user defined function (system series) to convert the month into spanish words (either full names or short names). Parameters below:

in string IN_string; { String containing values separated by token character }
in string IN_token; { Token character used in String }
in integer IN_position; { Position of value to return }

For example "Jan,Feb,Mar,Apr,May,Jun,Jul,Aug,Sep,Oct,Nov,Dec", ",", (c) Month

Then the final calculated field can take the 3 strings and concatenate them.

For more information on the user defined report writer functions look at the Report Writer programmer's guide in the Software Development Kit (SDK). The SDK can be installed from the Tools folder of CD 2 of the install CDs.

David Musgrave [MSFT]
Escalation Engineer - Microsoft Dynamics GP
Microsoft Dynamics Support - Asia Pacific

Microsoft Dynamics (formerly Microsoft Business Solutions)
http://www.microsoft.com/Dynamics

mailto:David.Musgrave@online.microsoft.com
http://blogs.msdn.com/DevelopingForDynamicsGP

Any views contained within are my personal views and not necessarily Microsoft policy.
This posting is provided "AS IS" with no warranties, and confers no rights.

Quick Links

Leaderboard