I am confused as to the result I get in a query.
If I have an expression that I run format in such as
Format([tbl]![myDATE],"mmddyy")) Doing this to standardise the output.
I would expect to get the month/day/year as two digit numbers but I don't in fact I get something totally different.
putting in 012495 (Jan 24 1995) as mydate gives me 031734
What is happening?