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

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".

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?

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