Date and time fields should have a consistent format

NETKEEPER^{^{^�}}
nklin1.gif (3727 bytes)
|Home|Products|Demos|Tech Support|Top FAQ list| Help Desk Software| CRM Software|

Date and time fields should have a consistent format
Document ID : 000-000921 Created:11/19/2004 Last changed on:11/19/2004

Imported or created date and time fields should have a consistent format. Use the same format that NetKeeper uses to save the date and time.

Check the correct format using Microsoft Enterprise Manager or Query Analyzer and display the table. Enter or import the dates or time columns to match the format used by NetKeeper.

Most columns use the century 101 format in MS SQL server (MM/DD/YYYY) MS SQL server will also do conversions. What is important is that all you entered dates match the format created by NetKeeper.

This solution text WEB page is automatically generated from your knowledge base and service data by NetKeeper Help Desk Software or NetKeeper CRM software. You can customize the pages to your site's look and feel or even include advertisements.