Darren Smith
Well-known Member
- Joined
- Nov 23, 2020
- Messages
- 631
- Office Version
- 2019
- Platform
- Windows
When I ascend the date order in the field it loses lots of rows of data does anyone know why this is?
Yeah, those conversions functions can be a pain with the regional settings and date values where month/days can go either way.Often a work around is to link to or import the records (consider that to be a staging table) then append to a secondary table where the fields are properly typed. Then anything that looks like a date will be properly stored as such. You are correct in that date values can be an issue with some people's regional settings. To convert as you suggest may require code because conversion functions will usually fail if they encounter nulls.