Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have the fields Month and Year in my table and now I have to extract date from Month and Year field, Please suggest how can achieve it.
load *, date(monthstart(Date#(Month&'/'&Year,'MM/YYYY'))) as Date Inline [
Month, Year
01, 2017
02,2017
03,2017
];
result: