Hi
I have about 40 date fields in various tables in my db. Some are static and some are created using a query. They all obviously have different column/field names.
I understand that Access stores dates in a numeric value and shows it in the US format mm/dd/yyyy by default. If I use UK settings on the local PC it displays the date correctly but all my calculations are thrown out of whack. When set back to US - all good. I have read quite a few posts but still don't understand how to get ALL the dates in my db to display as dd/mm/yyyy irrespective of the Locale setting and also keep my calculations intact.
I have read up Allen Brownes post and understand the logic but I have no idea on how to implement it.
This is his code:
'strWhere = "[Holiday] >= #" & Format(startDate, "yyyy\/mm\/dd") & "# " & _
'"AND [Holiday] <= #" & Format(endDate, "yyyy\/mm\/dd") & "#"
'"[Holiday] = #" & Format(dateCurrent, "mm\/dd\/yyyy") & "# "
Do I create a separate function and how would I tell it that it must format ALL dates (not just holiday). Where would I do this?
How would I tell static date fields to use this function & how would I tell calculated date fields in a query?
How would I call it in SQL?
Please excuse the novice questions - but I really need the help.
Could you please provide the code
Thank You In Advance