Hi, Richard,
MESSAGEBOX("The date should be between 31/12/2000 and "+TRANSFORM(DATE(),"@D")+".")
will print the date using the current SET DATE format (the CENTURY setting will also apply). @E will print the date using British format but I think you should stick to the more general setting.
> I have put a validation on a textbox for a date and also an accompanying error message for false. The error message appears like below:
>
>MESSAGEBOX("The date should be between 31/12/2000 and "+DTOC(DATE())".")
>
>
>This works fine but the problem is that DTOC(DATE()) gives the date in American format. I've checked the systems date and also changed from the Tools->Options->Regional to British but it still doesn't work. Can someone help me out please? Thanks in advance.
bye
----------------------------------
António Tavares Lopes