Got a year in one field and a month in another? DateSerial puts the pieces together into a real date value. The order is year, month, day. If you only recorded the year and month, using day 1 is an assumption, not a recovered date. In this video, I show you how to build the dates, handle missing source values, and use an update query to save the results. Back up your database first.

For a complete step-by-step video tutorial on this topic, including additional examples and explanations, please visit https://599cd.com/DateSerial.
No comments:
Post a Comment