Convert number to month - 1 field

[#1]

Hi,

Can someone provide answer to how I can convert number on the LatestBidMonth field on the attached to actual month text (e.g January).

1 needs to be January, 2 February etc.

Chris

[sunny_talwar]

You can try like this:

Month(Date#(LatestBidMonth, 'M')) as LatestBidMonth

[migueldelval]

Hi Chris,

Could you explain a little bit your question?

Regards

Miguel del Valle

[#4]

Hi Sunny,

Ok and where does this go? In the script or within properties of table box?

Chris

[sunny_talwar · Accepted solution]

Check this out

Script:

Table:

LOAD Band,

    NumberBids,

    LatestBidYear,

    LatestBidMonth as Temp_LatestBidMonth,

    Month(Date#(LatestBidMonth, 'M')) as LatestBidMonth

FROM

calenderqv.xlsx

(ooxml, embedded labels, table is Sheet1);

[sunny_talwar]

Script... Provided the script below for the sample your have provided

[#7]

Want to able to assess bids but not easy to do when numbers. With actual text can easily see bids per month.

Chris

[antoniotiman]

Try

Date(Date#(LatestBidMonth,'MM'),'MMMM')  as Month