Date

[upaliwije]

In my I have two fields Month & Year. I want to extract Date using Month and year fields. Date may be last date of the month

Eg

Year  Month   Required DAte

2012  01         31-JAN-2012

2012  12         31-DEC-2012

Is there a way to do this please help me.

[Sokkorn]

Hi Upali,

Maybe you can try this:

[Data]:

Load

     [Year],

     [Month],

     Date(MonthEnd(Date#([Year] &'-'& [Month],'YYYY-MM')),'dd-MMM-yyyy')     AS [NewDate],

     ...

From...

Regards,

Sokkorn

[Gysbert_Wassenaar]

Or like this:

Table1:

Load

    date(monthend(makedate(Year,Month)),'DD-MMM-YYYY') as NewDate

From ....