Gustav Brock
gustav at cactus.dk
Wed May 14 14:06:55 CDT 2003
Hi Shamil Yes, you are probably right about YYYY/MM/DD - I just don't have the nerves to try! /gustav >> Format(Date, "MM\/DD\/YYYY") >> is the one to use. It will never fail. > Gustav, > I think that > Format(Date, "YYYY\/MM\/DD") > should never fail too. > As for this: Format(Date, "DD\/MM\/YYYY") - as I wrote it will work > correctly if day number is greater than 12... - of course it CANNOT be > recommended for use... > And I think that Format(Date, "YYYY\/MM\/DD") is easier to interpret for > Europeans when they see the result of such formatting in SQL expressions...