Is there any way to format the category label on a chart besides through query functions. I am using SQL express and the closest format I can get is HH:mm:ss. Would like to strip it down to HH am/PM.
[attachment=0]Chart.png[/attachment]
Is there any way to format the category label on a chart besides through query functions. I am using SQL express and the closest format I can get is HH:mm:ss. Would like to strip it down to HH am/PM.
[attachment=0]Chart.png[/attachment]
Found a way to do it through my SQL query.
select RIGHT(CONVERT(VARCHAR(26), logdatetime, 100), 7)