RE: Set TimeStamp To Beginning of day

You need a : in front of all your RPG fields like

where date(Modify_Time) = :Selectdate

Scott

-----Original Message-----
From: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of (WalzCraft) Jerry Forss
Sent: Wednesday, April 30, 2014 9:07 AM
To: 'RPG programming on the IBM i (AS/400 and iSeries)'
Subject: RE: Set TimeStamp To Beginning of day

Hi All,

Finally have a little time to get back to this. Sorry for the delay.

I have tried as many combinations as I can think of but keep getting the compile error SQL0206 <field name> not in specified tables.

The things I have tried are:
SelectDate (Date Data Type)
StartTime (Timestamp)
EndTime (Timestamp)

where date(Modify_Time) = Selectdate

Where Modify_Time >= StartTime And
Modify_Time <= EndTime

Where Modify_Time >= Timestamp(StartTime) And
Modify_Time <= Timestamp(EndTime)

The line below works as expected in a different pgm. This selects everything older than the number of days to the second.

Where Modify_Time < Current TimeStamp - :Days days;

It always gives me the same error.
I think the Modify_Time from the IFS is in a different type of format, isn't it?

What the heck am I doing wrong?

Thanks!!