Format of Date Function has changed!

[JamesFletcher]

Hi All,

I use the vba Date function in conjunction with the TODAY() formula to check whether an email has been sent today.
The problem I am having is that the date format has changed from dd/mm/yyyy to mm/dd/yyyy.
This has changed over the weekend and I can't figure out how to change it back.

This is the original code I was using:

Please Login or Register  to view this content.

I tried using this as well:

Please Login or Register  to view this content.

I've tried formatting the cells as well but the date in the cell keeps coming out in the format mm/dd/yyyy.

[humdingaling]

did you declare tdate as date?
also is it a textbox involved?

[JamesFletcher]

There are no text boxes.
Here is the whole code and as I said, it worked fine last week and nothing has changed:

Please Login or Register  to view this content.

[JosephP]

not real sure what the variable is for at all

Please Login or Register  to view this content.

oughta work

[humdingaling]

without trying to replicate your whole sheet.....

Please Login or Register  to view this content.

[JamesFletcher]

That is so odd!

Thank you so much for your help guys...much appreciated.

[Andy Pope]

it worked fine last week and nothing has changed:

The thing that changed was the date. Last week there was no ambiguity with dates such as 28/5/2013. This week there is 3/6/2013 June 3rd or March 6th