Date error

[rrdwitt]

Hello all, I have tried the Format date function and several others but

I cannot get the date formatted correctly. Seems a fairly simple rule but his one is not working. The number coming in is "01252020" I would like it to read January, 25 2020. But I keep getting the attached error.

 

Thanks

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

[rrdwitt]

Thank you, I will give it a try. Privacy in mind, are you someone I used to work with? Your user name sounds familiar

[sschardan]

You are welcome. And privacy in mind, yes.