Formatting Date

[Exodus]

Formating Date

I nmy Report I have a TextBox

The value starts off as a String I think but then has a date field

I need to format it in Long Date How do I do this



"We will be using the facility and be delivering on" & " " & [DeliveryDayCalc] & " " & " If ther are any questions please cal

 

[GumbyD]

You should be able to use the format function on that field in the middle of your concatination like this:

"We will be using the facility and be delivering on" & " " & Format([DeliveryDayCalc],"mmmm dd"", ""yyyy")& " " & " If ther are any questions please cal

See if that works for you

GumbyD

 

[Exodus]

Thanks GumbyD

That worked. I had tried to work the format Funtion but I don't know expressions that well.