Date/Time Macro Issue

[ScabbyDog]

I have the below which generates an email if the date in column D is in the past. I am going to alter column D so that it contains a date and a time and the column is format dd/mm/yyyy hh:mm:ss and so then I'd only want the macro to run if what is in column D is in the past.

Any help?

Please Login or Register  to view this content.

[nathansav]

use now instead of date

[ScabbyDog]

I used now nathan but for some reason the date and time are displaying as a huge number like 418660.895833333333 in the column so I assume that's what's stopping it from working?

[ScabbyDog]

Should I be using something like CDate or similar in my code to make it work?

[ScabbyDog]

Perhaps it is how I am using column D. It is a formula which is 'Exx&Fxx' where xx is the row number. Column E is a date and Col F is a time.

[romperstomper]

You should be using + not & in the formula.

[ScabbyDog]

Sorted now guys. Thanks for the help