Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
i want to change date formate D20190515 to 20190515
my dates rows, i have convert fileds using cross table.
EX:
CrossTable(Date,Values,5)
[Test]:
LOAD
[Test1],
[Obj],
[Descr],
[Score],
[Column],
[D2010515],
[D2010515],
Out:
i want to show month and year wise
Please help me.
Thanks in Advance.
Regards,
Subba
@Subba55 try below
Data:
CrossTable(Date,Values,5)
LOAD
[Test1],
[Obj],
[Descr],
[Score],
[Column],
[D2010515],
[D2010515],
....
FROM table;
New:
LOAD *,
date(date#(right(trim(Date),8),'YYYYMMDD')) as new_date
resident Data;
drop table Data; drop field Date;
Yu can now create calendar using new_date field.
@Subba55 try below
Data:
CrossTable(Date,Values,5)
LOAD
[Test1],
[Obj],
[Descr],
[Score],
[Column],
[D2010515],
[D2010515],
....
FROM table;
New:
LOAD *,
date(date#(right(trim(Date),8),'YYYYMMDD')) as new_date
resident Data;
drop table Data; drop field Date;
Yu can now create calendar using new_date field.
Thank you so much Kushal, its working.