Re: Query400 question

The following is help text from the WRKQRY command.
Looks like it is possible provided that you use fields of type DATE.
You will need to manipulate the DD/MM/YY format to a valid date.
I have never done this but always intended to try it out , I would be
interestred in knowing
how it works out.
=========================================================
  DAYS:
           Syntax for:     DAYS(expression)
           Example of:     DAYS(CURDATE) - DAYS(HIREDATE)
      The DAYS function returns a numeric representation
      of a date. The expression must evaluate to a date,
      a timestamp, or a valid string representation of
      a date.
==========================================================

Andreas.KOPP@de.imp-group.com wrote:

> I have a question concerning Query400.
>
> I have a field in format date  (DD/MM/YY) and I would like to create a new
> field containing the original date  plus 1 day.
>
> How can I add a day to date?
> Is this possible?
>
> Regards
> Andreas
>
> +---
> | This is the BPCS Users Mailing List!
> | To submit a new message, send your mail to BPCS-L@midrange.com.
> | To subscribe to this list send email to BPCS-L-SUB@midrange.com.
> | To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner: dasmussen@aol.com
> +---


+---
| This is the BPCS Users Mailing List!
| To submit a new message, send your mail to BPCS-L@midrange.com.
| To subscribe to this list send email to BPCS-L-SUB@midrange.com.
| To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: dasmussen@aol.com
+---