Date formating in email body

[Evergreenh]

I have a little problem with date formatting. I’m in the UK, and all over our database the dates format perfectly in UK format, except for in one area. That is if I use a date field in the middle of text in the body of an email that is created from the Send Email script step.

So the date 31^st December 2011 which appears everywhere as 31/12/11 looks like this in the email:

“whatever text is to the left 12/31/11 whatever text is to the right”

So this means that we are sending emails out with the following explanation:

“whatever text is to the left 12/31/11 (date may appear in US format) whatever text is to the right”.

This wouldn’t be such a big problem if we weren’t an events led company running over 80 events every month.

Could anyone help me with this?

Thanks in advance

Kelly

[doughemi]

Create a new DateDisplay field = day(YourDateField) & "/" & month(YourDateField) & "/" & year(YourDateField)

Change the email body field calc to

"whatever text is to the left " & DateDisplay & " whatever text is to the right".

[comment]

all over our database the dates format perfectly in UK format, except for in one area.

That's very strange. Can you reproduce the problem in a brand new file?

[Evergreenh]

Create a new DateDisplay field = day(YourDateField) & "/" & month(YourDateField) & "/" & year(YourDateField)

Change the email body field calc to

"whatever text is to the left " & DateDisplay & " whatever text is to the right".

Oh you are lovely!!! Thats worked straight away.

I wish I had aksed this question 2 years ago!!!

Thanks for that

Kelly

X