Join Month and Year into Single Field Date

[amithmurali]

Hi guys,

I have a Problem now. i have stocks table in which they give month and year in different fields. i want to join them into a single field. as described below.

Month	Year
2	2015
3	2015
4	2015
5	2015

I have month and year in two different fields in my table.

i want to join them into a single field . like this,

Date
28-02-2015
31-03-2015
30-04-2015
31-04-2015

*The date should be end of the Month.

[alexandros17]

Try with:

monthend ( Year & '/' & Month & '/' & '01' )

let me know

[amithmurali]

can you please explain me how to write the script. Sorry i am newbie here.

[alexandros17]

Probably you are loading data with a sql query, something like

SELECT

....

From

....

Where

...

Then, add to your list of fields a new one in this way:

SELECT

....

Year,

Month,

monthend ( Year & '/' & Month & '/' & '01' ) as myDate

From

....

Where

...

Let me know

[vishsaggi]

Hello Amith,

As Alessandro mentioned using that script as a separate field for date. Like below

Load Month,

        Year,

        Monthend(Year & '/' & Month & '/' & '01') As Date

FROM <Your Table Name> ;

Thanks,

V.

[amithmurali]

i tried this and the date field is empty.

[vishsaggi]

Try using date function and check. Like

Date(Monthend(Year & '/' & Month & '/' & '01'), 'DD-MM-YYYY') As Date

V.

[alexandros17 · Accepted solution]

You're right I made a mistake,

try this

MonthEnd(MakeDate(Year, Month , 1)) as myDate

[amithmurali]

Thanks. it worked.

[amithmurali]

ur ri8