Forum Discussion

sedens's avatar
sedens
Contributor
2 years ago
Solved

Leading zeros are not dropped when using %#d in aqConvert.DateTimeToFormatStr function

I need to remove leading zeros from the day when using date formats e.g. 7/15/1994 instead of 07/15/1994 however when I use the aqConvert.DateTimeToFormatStr function it does not drop the leading zer...
Script Tests
Web Testing
  • npaisley's avatar
    npaisley
    2 years ago

    Hi sedens!

     

    Pardon any confusion here on my part, but it appears you are looking to drop the zero from the Month in this case? Which means we need to apply the '#' to the Month section as well, instead of just the Day. 

     

    This formatting removes all the zeros from your date in a script I built out;

    aqConvert.DateTimeToFormatStr(myDate, "%#m/%#d/%Y")

     

    I hope this helps!

     

npaisley's avatar
npaisley
Staff

Hi sedens!

 

Pardon any confusion here on my part, but it appears you are looking to drop the zero from the Month in this case? Which means we need to apply the '#' to the Month section as well, instead of just the Day. 

 

This formatting removes all the zeros from your date in a script I built out;

aqConvert.DateTimeToFormatStr(myDate, "%#m/%#d/%Y")

 

I hope this helps!

 

sedens's avatar
sedens
Contributor
2 years ago

Ah yes ... it appears I have mixed up my date formats again. I'm an Australian living in the US so I've mixed up the formatting of the dates. In Australia, dates are generally d/m/yyyy while the US has dates as m/d/yyyy which makes it easy to mix them up. 

 

Thank you for your help. I was using the wrong format specifier. Using #m worked as well as #d if I had made the month a single digit. That should have been my clue I was using the wrong specifier.

 

Thank you for your help!

  • npaisley's avatar
    npaisley
    Staff
    2 years ago

    Hey sedens!

     

    I have often thought that the US should use the same date methods, I think it makes more sense. And I can only imagine the confusion in your head at times, lol! 

     

    Glad to hear that worked, good luck moving forward!