This is the best solution i could come up with. You DATE is text field which means you cannot use date functions on. You can change that to the date format using the following syntax in your script:
Date(MakeDate(Left(Right(DATE, Len(DATE)-6), Len(Right(DATE, Len(DATE)-6))-6),
Right(Left(DATE, Len(DATE)-11),len(Left(DATE, Len(DATE)-11))-3),
Hope this helps.
line_chartvrl.qvw 140.8 K
Thank you for your reply and attachment but the business wont accept a bar graph as the current BI tool is able to give them the data in a line chart.
Also I believe a much easier way to get the inline table to show the DATE field as a date data type would be to set the TimeStampFormat to being;
SET TimestampFormat='DD/MM/YYYY hh:mm[.fff]';
That seems to have worked to get the value translated.