Creating Date field from two separate fields for Year and Month

[alkesh_sharma]

Hello,

I have two separate fields for Year and Month.

can I create a date field from it?? Days I can take random.

Please help....

[#2]

You can use Date(Date#(Year&MONTH,'YYYYMM')). it'll give the start date for that month.

[alkesh_sharma]

Hello Krupasagar,

Its not working...is there any other option??

[Anonymous]

Hi

insert dates

1,

2,

.

.

.

.

31,

[#5]

Hi Sharma, Try with MakeDate function like below:

     MakeDate(YEARFIELD, MONTH) AS DATEFIELD

If you ignore day parameter, it takes 1st of month.

[tresesco]

MakeDate(Year,Month,1) as Date

[alkesh_sharma]

Nope, still not working...