[sschardan]

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");