Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a column "DATE" with values as JAN 2011, APR 2012, AUG 1999.....etc.
I need to create a date object. Can anyone help me with this ?
Hi,
Which object you want to create.
Regards
Anand
question wrong pls check it once and come back
Try like this
load *, date(date#(DateField,'MMM YYYY')) as Date ;
load * Inline
[
DateField
JAN 2011
APR 2012
AUG 1999
];
Regards
ASHFAQ
Actually, I m preparing a dashboard. In a table I have a Column called
DATE
Jan 1999
Apr 2000
-
-
-
etc.
I need to create a Date Object which displays, Month and year
create a date object with date field. u will see as expected
Create the master calendar for this and create the date field.
Regards
Anand