date issue mm/dd/yyyy and dd/mm/yyyyy

I have the below code that goes through pivot tables/charts and makes certain dates invisible:

Please Login or Register  to view this content.

But this line of code shows me that the date is in the format mm/dd/yyyy. How do I rectify this?

Please Login or Register  to view this content.

As this messes up my if statement

Please Login or Register  to view this content.

It is stored in the format dd/mm/yyyyy, but not sure how to correct the conversion??

Any ideas?

Thanks

thanks wamp, but I found a better way using existing varialbls. I use FirstDate to control my if loop.

Had a go at the fromat thing but it looked a bitmore difficult, cheers though. I,m sure I will revisit that

Please Login or Register  to view this content.