September 29, 2006 at 4:26 am
I have a chart that has months as the X Axis, I've set the interval to 3 so it shows every three months. If I have no format code the date comes out in dd-mm-yyyy hh:mm:ss. If I use d or mm-yy or dd-mm-yy or mm/yy or dd/mm/yy (and a whole host of other combinations) the month part of the date always comes out as 00.
Does anyone know what format code to use to get the month element to report properly. I've only been trying to change the properties in the Chart properties multi-tab form. If there is somewhere else I should be trying, please let me know.
(I'm working in UK date formats).
October 2, 2006 at 8:00 am
This was removed by the editor as SPAM
October 2, 2006 at 9:21 am
Try with MM instead of mm
October 3, 2006 at 4:11 am
That must of been the one permutation I missed!
Many thanks that works.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply