[AccessD] All-In-One Date format Function:

Stuart McLachlan stuart at lexacorp.com.pg
Wed Oct 21 16:20:10 CDT 2009


That depends on your "regional settings".

On my machine:

? format(cdate("01/02/03"),"d mmm yyyy") 
1 Feb 2003


On 21 Oct 2009 at 14:48, Heenan, Lambert wrote:

> Cdate can handle just about anything that looks like a date and if
> it's unambiguous will give you a real date back. It will of course
> assume mm/dd/yyyy when the input data is not clear. 



More information about the AccessD mailing list