Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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....
You can use Date(Date#(Year&MONTH,'YYYYMM')). it'll give the start date for that month.
Hello Krupasagar,
Its not working...is there any other option??
Hi
insert dates
1,
2,
.
.
.
.
31,
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...