User (Legacy) Posted February 15, 2002 Report Share Posted February 15, 2002 Hi, I have the following code : With cfx.Axis(AXIS_X) .Format = "Mmm-yyyy" .Min = dtStart ' dtStart and dtEnd are date variables .Max = dtEnd ' Increase the step by 120 days .STEP = 120 End With According to the Programmers Guide, I should be able to define a specific format. However, the above code is producing huge numbers instead of "Jan 2001". Any suggestions? Wendy Link to comment Share on other sites More sharing options...
User (Legacy) Posted February 15, 2002 Author Report Share Posted February 15, 2002 I saw an example where the first character of the format string must be a 'x'. Don't know why. Search the group. GregM "Wendy Gatanis" <wgatanis@distributive.com> wrote in message news:3C6D72E7.9070103@distributive.com... > Hi, > > I have the following code : > > With cfx.Axis(AXIS_X) > .Format = "Mmm-yyyy" > > .Min = dtStart ' dtStart and dtEnd are date variables > .Max = dtEnd > ' Increase the step by 120 days > .STEP = 120 > > End With > > According to the Programmers Guide, I should be able to define a > specific format. However, the above code is producing huge numbers > instead of "Jan 2001". > > Any suggestions? > > Wendy > Link to comment Share on other sites More sharing options...
Software FX Posted February 15, 2002 Report Share Posted February 15, 2002 What is Mmm ? Do you mean: Format = "DMM-yyyy" This format will display: 05-2002 06-2002 07-2002 .... -- FP Software FX, Inc. Link to comment Share on other sites More sharing options...
User (Legacy) Posted February 18, 2002 Author Report Share Posted February 18, 2002 I did Mmm so that it displays Jun, Jul, Aug,etc... It says in the API help file, Axis Format defition (Remarks section) that you need to do "MMM" to get this out put. Thanks, Wendy SoftwareFX Support wrote: > What is Mmm ? > > Do you mean: > > Format = "DMM-yyyy" > > This format will display: > > 05-2002 06-2002 07-2002 .... > > > -- > FP > Software FX, Inc. > > > Link to comment Share on other sites More sharing options...
User (Legacy) Posted February 18, 2002 Author Report Share Posted February 18, 2002 Thank you Greg, That worked. When I did .Format = "xMMM-yyyy" I get Jun-1999, Jul-1999, etc... You might want to know too that the format function is case sensitive. If I .Format = "xMmm-YYYY" it does not work. Thanks, Wendy Greg McCarty wrote: > I saw an example where the first character of the format string must be a > 'x'. Don't know why. Search the group. > > GregM > > "Wendy Gatanis" <wgatanis@distributive.com> wrote in message > news:3C6D72E7.9070103@distributive.com... > >>Hi, >> >>I have the following code : >> >>With cfx.Axis(AXIS_X) >> .Format = "Mmm-yyyy" >> >> .Min = dtStart ' dtStart and dtEnd are date variables >> .Max = dtEnd >> ' Increase the step by 120 days >> .STEP = 120 >> >>End With >> >>According to the Programmers Guide, I should be able to define a >>specific format. However, the above code is producing huge numbers >>instead of "Jan 2001". >> >>Any suggestions? >> >>Wendy >> >> > > Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.