Extra Space in "Day" of Crystal "ToText" to Date Format Function (CR 2008)

[starkley]

thread767-1352528

As in the post previously referenced, I noticed an extra space before the day when formatting using the following:

(ToText(Today + {WorkOrders.shelf_life},('M/d/yy')))

This gives me a result of "12/ 6/13" when I am expecting "12/6/13"


Has anyone found a resolution to this? I too think it's a bug, so I have this ugly workaround:

ToText(Month(Today + {WorkOrders.shelf_life}),0,'') & '/' & ToText(Day(Today + {WorkOrders.shelf_life}),0,'') & '/' & Right(ToText(Year(Today + {WorkOrders.shelf_life}),0,''),2)


Better ideas?

 

[pmax9999]

The simplest way to get rid of the space would be to use the Replace function, eg

ReReplace(ToText(Today + {WorkOrders.shelf_life},'M/d/yy'), " ", "")

Pete

 

[starkley]

Fantastic, that works!

Great, simple, elegant solution to an obvious bug.

(Fixed the syntax by removing extra "Re"):

Replace(ToText(Today + {WorkOrders.shelf_life},'M/d/yy'), " ", "")

 

[pmax9999]

I must have developed stutter! Or just not very good at "Copy and Paste".

Glad it helped.

Pete