Home > IT Answers > Development > Converting System Date into NUMERIC
Petrabyte
30 pts.
 Converting System Date into NUMERIC
Conversion functions, Numeric
Is there a way to use the system date & converter to YMD and use it in the selection OPTION?

Software/Hardware used:
ASKED: June 27, 2008  3:16 PM
UPDATED: June 27, 2008  4:43 PM
RELATED QUESTIONS
Answer Wiki:
Hi, Can you give us a few more details of what you mean? Which system are you using? What do you mean by selection OPTION? Regards, Martin Gilbert. We are a I5 shop, using as/400 query, but need to use the system date to calculate AGEING REPORTs on release date, charge date, etc. HAVE used the user define field but it only allow me have the system date in CHARACTER to DISPLAY OR PRINT it. but I need to use it in the SELECTION OPTION OF AS/400 QUERY as a numeric field?
Last Wiki Answer Submitted:  June 27, 2008  4:43 pm  by  Gilly400   23,625 pts.
All Answer Wiki Contributors:  Gilly400   23,625 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

We are a I5 shop, using as/400 query, but need to use the system date to calculate AGEING REPORTs on release date, charge date, etc. HAVE used the user define field but it only allow me have the system date in character to display it. but I need to use it in the SELECTION OPTION OF AS/400 QUERY as a numeric field?

Petrabyte
 30 pts.