I have two separate fields for Year and Month.
can I create a date field from it?? Days I can take random.
You can use Date(Date#(Year&MONTH,'YYYYMM')). it'll give the start date for that month.
Its not working...is there any other option??
Hi Sharma, Try with MakeDate function like below:
MakeDate(YEARFIELD, MONTH) AS DATEFIELD
If you ignore day parameter, it takes 1st of month.
MakeDate(Year,Month,1) as Date
Nope, still not working...
Retrieving data ...