topic Function Date in QlikView

Function Date

Tue, 21 Jan 2014 17:43:43 GMT

I use the function Date('10/08/2012','D MMMM YYYY') and return "10 agosto 2012".

How can i translate MMMM in english language ?

I want that the function Date('10/08/2012','D MMMM YYYY') return "10 august 2012"

Thanks

rustyfishbones — Tue, 21 Jan 2014 17:49:32 GMT

Hi,

Have you tried changing the MonthNames Variable so it is like below?

Anonymous — Tue, 21 Jan 2014 17:59:01 GMT

Claudio

For your long Month Names, you'll need to add a variable LongMonthNames

Set LongMonthNames =

'January;February;March;April;May;June;July;August;September;October;November;December';

See this blog post Roman Emperors and the Month Names for loads of Month Name information.

Best Regards, Bill

Tue, 21 Jan 2014 18:09:39 GMT

Perfect

Thanks

Anonymous — Tue, 21 Jan 2014 18:16:05 GMT

Claudio

Did you find any of the replies a Helpful Answer or even a Correct Answer ? Nudge, nudge.........

Best Regards, Bill