Date field from the Month and Year Field

[#1]

Dear All,

I have one requirement . can any one tell me how i find the date field from the Month and Year Field.

I have the Value in the Field  Fiscal Year like 2011,2012,2013..

Month - Apr, May , June....etc.

Regards

Deepak

[tresesco]

Use Date#() like:

Date(Date#(YearField&MonthField, 'YYYYMMM')) as Date

[datanibbler]

Hi Deepak,

for a complete date, you are missing the day, but never mind. Try the MAKEDATE() function. You might have to play around with the formatting - I have, in some instances, introduced a mapping_table where the monthnames (Jan, Feb, mar ...) are mapped to numbers (1, 2, 3 ...)

HTH

Regards,

DataNibbler