Sage 100

Argh, losing my patience.  I'm trying to achieve m/d/yyyy in a Crystal formula.  The closest I got was this, ToText(Cdate({SO_SalesOrderWrk.PromiseDate}),"M/d/yyyy"), although it returns 4/ 8/2022 (notice the space in front of the day; can't figure out how to prevent that).

------------------------------
Brett Zimmerman
Net at Work
Greater Boston Area
------------------------------

Hmmm, I guess i nearly always use the "MM/dd/YYYY" form so I get the leading zeros... I hadn't noticed a leading space.

Have you tried using the Replace() function to remove the space?  Also, probably not important, but is Cdate() necessary?  Isn't PromiseDate already a date field?

i.e.   replace (ToText(Cdate({SO_SalesOrderWrk.PromiseDate}),"M/d/yyyy")," ","")

------------------------------
Randy Marion
------------------------------

Thanks, Randy!  Looks like that might do the trick as I also just found this: https://stackoverflow.com/questions/25428506/leading-blank-space-converting-date-to-string-in-crystal-reports.  Yes, I probably don't need Cdate; I had tried it with and without, same result.


------------------------------
Brett Zimmerman
Net at Work
Greater Boston Area
------------------------------

Original Message:
Sent: 09-02-2022 11:57
From: Randy Marion
Subject: controlling date format in Crystal formula m/d/yyyy

Hmmm, I guess i nearly always use the "MM/dd/YYYY" form so I get the leading zeros... I hadn't noticed a leading space.

Have you tried using the Replace() function to remove the space?  Also, probably not important, but is Cdate() necessary?  Isn't PromiseDate already a date field?

i.e.   replace (ToText(Cdate({SO_SalesOrderWrk.PromiseDate}),"M/d/yyyy")," ","")

------------------------------
Randy Marion
------------------------------