Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi all, can anyone help me on how to convert a date field (MMM-YYYY) to an interger?
You are writting this:
=num(Date#('Jul-2013', 'DD-MMM-YYYY'))
But it won't work because the formula its expecting the day and you only write jul-2013.
Try writting 01-jul-2013... or =num(Date#('Jul-2013', 'MMM-YYYY'))
HI
Temp:
LOAD * INLINE [
Date, Sales
May-2013, 1000
Jun-2013, 2000
];
Date:
Load *,
Num(Date#(Date,'MMM-YYYY')) as DateField
Resident Temp;
Drop table Temp;