RE: date operations

[Bill Erhardt <ERHARDT@xxxxxxxxxxxxx>]

I've done Current(date) - 1 Day to get yesterdays date, so I think
Current(date) - 1 month should give you the xth day of last month.

> -----Original Message-----
> From: pedro.reis@valeo.com [SMTP:pedro.reis@valeo.com]
> Sent: Friday, January 10, 2003 9:24 AM
> To:   midrange-l@midrange.com
> Subject:      date operations
> 
> Hi
> 
> Does anyone know if its possible to do date operations on query400?
> For exemple, is it possible on a query do something like : current date -
> 1
> month    (200301 -1 mont = 200212)
> 
> 
> 
> 
> 
> 
> Cordialement,
> Best regards,
> -------------------------------------------------------------------
> Pedro Reis
> Information System
> e-mail: pedro.reis@valeo.com
> Phone: 351-258 350 725
> Fax: 351-258 350060
> --------------------------------------------------------------------
> VALEO - Electronics & Connective Systems
> Viana do Castelo - Portugal
> --------------------------------------------------------------------
> 
> "This e-mail message is intended only for the use of the named
> recipient(s).
> The information contained therein may be confidential or privileged, and
> its
> disclosure or reproduction is strictly prohibited. If you are not the
> named
> recipient, please return it immediately to its sender at the above address
> and destroy it."
> 
> 
> _______________________________________________
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list
> To post a message email: MIDRANGE-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo.cgi/midrange-l
> or email: MIDRANGE-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.