Converting System Date into NUMERIC

30 pts.
Tags:
Conversion functions
Numeric
Is there a way to use the system date & converter to YMD and use it in the selection OPTION?
ASKED: June 27, 2008  3:16 PM
UPDATED: June 27, 2008  4:43 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

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?

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Petrabyte
    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?
    30 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following