Thread: Date error
View Single Post
  #2  
Old April 5th, 2019, 07:01 AM
sschardan sschardan is offline
Regular Contributor
 
Join Date: Oct 2008
Location: St. Louis, MO
Posts: 97
Default Re: Date error

I'm sure there is a more concise way to do this, but this works:

var month = Left(Field("date"), 2)
var day = Left((Right(Field("date"), 6)), 2)
var year = Right(Field("date"), 4)

return FormatDate((month + " " + day + " " + year), "lm d, yyyy");
Reply With Quote