How to change Date Format

[Subba55]

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

[Kushal_Chawda · Accepted solution]

@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]

Thank you so much  Kushal, its working.