Conversion of dates for use with OnEBill System
PSS ID Number: 196152
Article Last Modified on 1/14/2000
The information in this article applies to:
This article was previously published under Q196152
SUMMARY
Outline for ConvertDate utility. This utility will convert from a calendar date into a long date number and from a long date number to a calendar date. Frequently, due to the nature of the database being used by the OnEBill back end, dates are required to be in a long date or date number format. This utility provides a nice GUI for selecting dates and converting them into this number that the back end requires.
MORE INFORMATION
(General information.)
The ConvertDate.exe utility is comprised of two components. 1. The GUI front end, a VB 6.0 form based executable that has three controls. A date picker, a time text box and a long date number text box. To use this utility, simply select the date that you are trying to convert, use the time picker to set the time to the appropriate time of day. (This supports 24 hr. time as well as AM/PM times). Next you will see the Long date text box updated with the value for the date. There is an option on the file menu which allows you open a file and then convert its contents from date numbers into long dates like MM/DD/YYYY HH:MM:SS from a 9999999999 type date value.
In the future, the utility will support converting from a long char date like MM/DD/YYYY HH:MM:SS to a long date number like 9999999999. This is not in there right now.
Additional query words: OnEBill, Date Conversion
Keywords: kbinfo KB196152
Technology: kbOnEbill110 kbOnEBillSearch kbZnotKeyword7