Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Bad date-time format string error

Status
Not open for further replies.
Dec 11, 2009
60
US
I have the below formula and it is returning the above error. Please help me with this issue:

If isnull({Command.weekending}) then "NULL"
else ToText({Command.weekending},","mmddyyyy")
 
If isnull({Command.weekending}) then
"NULL" else
ToText({Command.weekending},"MMddyyyy")

I removed the extra " and changed the case for the month format.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top