A date field in my query is stored as decimal(yy,yym,mdd). The query is a report that is converted into PC doc format and emailed to the user automatically. When the user opens the report using EXCEL, the date field is shown as decimal numbers no matter what type of date format is chosen. Is there a way for me to automatically convert the field to date from the query itself?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Changing decimals in AS400 to date in Excel 1
- Thread starter Ju5
- Start date
-
1
- #2
Try defining a result field in the query as a string. So, ResultField will be 20070601 (for examnple).
From there, you can define additional result fields, that will substring the initial result field.
With some manipulation, you can create a text result field that will refresent 20070601 as 06/01/2007
From there, you can define additional result fields, that will substring the initial result field.
With some manipulation, you can create a text result field that will refresent 20070601 as 06/01/2007
- Status
Similar threads
- Locked
- Question
- Locked
- Question