Updating a date field in msacess

Please join our friendly community by clicking the button below - it only takes a few seconds and is totally free.

You'll be able to ask any tech support questions, or chat with the community and help others.

Examples: The third example demonstrates how to concatenate a date into a SQL string.Sub Pys Time Stamp dim o Ctrl Date as object, o Ctrl Time as object dim Pys Date as new The answer unfortunately is no, DEFAULT can not be computed. If you are outside the USA, or developing applications that may be used in other countries, you must know to handle dates in Access. In some countries, the date separators are dots or dashes, not slashes.

Leave a Reply