
>>>>HELP ME WITH DATEVALUE IN UK FORMAT<<<<<<<
I am creating a program which has meant to compare the current date obtained form
DATE$ with a date entered in text format from a Database.
If the current date is passed the database date then I want to alarm the
user. To do this I thought I would employe the DATEVALUE function. But It appears
that dispite my windows being set up correctly DATEVALUE only returns a value when
the date is in US format. + DATE$ only returns the date in US format, but can be reformatted
I must work in UK date format, Please can anyone help me?
Johnathan Briggs (Scotland)