How do i convert number 1.... to 12 in my listbox to calender months

[#1]

Hello

I have 12 numbers in my listbox 1,2,3,4......12 and want them to display in my dashboard as Jan, Feb, Ma. How do I resolve this?

[carvalguil]

Try:

=Month(Makedate(1, [your field]))

[#3]

Hello Carvalho

Is it possible to coin out period in Quarter into 4 quarter of the year from the 12 months?

[carvalguil]

Always when I want the year quarter, I add a field in my LOAD like this:

floor(([Your Month Field] -1) / 3) + 1 as Quarter,

[MarcoWedel]

Hi Ema,

another method would be:

=Month(Date#(number,'M'))

But instead of doing it in a listbox as you suggested, you should rather create your Month field in the script accordingly:

LOAD number,
          Month(Date#(number,'M')) as Month,
          someotherfields
FROM yoursource;

hope this helps

regards

Marco

[MarcoWedel]

or just as:

=Ceil(number/3)

Here as well I recommend to do so rather at script level:

LOAD number,
          Ceil(number/3) as Quarter,
          ...
FROM yoursource;

hope this helps

regards

Marco