Regarding date format?

[d_koti24]

Hi All,

I have two fields like month,and year

Month	Year
3	2015
4	2015
5	2015
6	2015
7	2015

i want to display monthyear in List box

like Monthyear:2015-03,2015-04,-----2015-07

How to achive this?

regards,

kd

[marcus_malinow]

You can either modify your load script to assemble the field as

Year & '-' & Num(Month,'00')

Or use this as a calculated dimension

[settu_periasamy]

Hi,

Add the Field in Script like below.

Load *,Date(Date,'YYYY-MM') as YearMonth;

Load *,MakeDate(Year,Month) as Date;

LOAD * INLINE [

    Month, Year

    3, 2015

    4, 2015

    5, 2015

    6, 2015

    7, 2015

];

[rubenmarin]

If you want it in date DataType, so you can use date functions if needed:

Date(MakeDate(Year, Month), 'YYYY-MM')

[jagan]

Hi Koti,

Try like this

LOAD

Month,

Year,

Date(MakeDate(Year, Month), 'YYYY-MM') AS MonthYear

FROM DataSource;

Hope this helps you.

Regards,

Jagan.

[Gabriel]

Hi,

Try this

Temp_Data:

LOAD * INLINE [

    Month, Year

    3, 2015

    4, 2015

    5, 2015

    6, 2015

    7, 2015

];

Final:

LOAD

*,

Date(MakeDate(Year, Month),'YYYY-MM')                AS [Yr Mnth]

Resident Temp_Data

Order By Year, Month DESC

;

DROP Table Temp_Data;

[MarcoWedel]

Hi,

if you don't want to change your script, you could use a calculated list box with the already proposed expressions.

Some solutions could be:

hope this helps

regards

Marco