Re: SQL and Dates, help needed

Did you convert the numeric field to date before trying to compare?



From:   "Al Nelson" <Al.Nelson@xxxxxxx>
To:     <RPG400-L@xxxxxxxxxxxx>
Date:   09/08/2011 12:23 PM
Subject:        SQL and Dates, help needed
Sent by:        rpg400-l-bounces@xxxxxxxxxxxx



I'm trying to select all the records in a file that have yesterday's date.
The field in the file is defined as numeric 8 positions and 0 decimals.
It is in a YYYYMMDD format.

I would think a Select with Current Date - 1 would work but is does not.

any suggestions.

thanks

al

--
This is the RPG programming on the IBM i / System i (RPG400-L) mailing
list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.


--
This is the RPG programming on the IBM i / System i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.