Hi Team,
I need to get the number of whole days between two datetimes.
I thought this would give it to me but..
"select Cast(DateSent - DateTime Day as Integer) as iDays from APJobtickets"
DateSent and DateTime are both DateTimes.
I get this error.
"ElevateDB Error #700 An error was found in the statement at line 1 and column 33 (Expected AS or , but instead found Day)"

Help!

Regards & TIA,
Ian

Ian Branch wrote:

> Hi Team,
> I need to get the number of whole days between two datetimes.
> I thought this would give it to me but..
> "select Cast(DateSent - DateTime Day as Integer) as iDays from
> APJobtickets" DateSent and DateTime are both DateTimes.
> I get this error.
> "ElevateDB Error #700 An error was found in the statement at line 1
> and column 33 (Expected AS or , but instead found Day)"
>
> Help!
>
> Regards & TIA,
> Ian

Hi Ian,

"select cast("DateSend"-"Day" as integer) as iDays from APJobtickets"

should work.

Brgds, Yusuf

Ian


select CAST ((DateSent - DateTime ) DAY AS INTEGER) as iDays from APJobtickets

If you just want it for display purposes and don't want to do arithmetic on individual rows (eg SUM will work)

select (DateSent - DateTime ) DAY as iDays from APJobtickets

I don't know if it rounds up or down or does bankers rounding so you'd need to test

Roy Lambert

Hi Roy,
Neither work.
I wonder if it is because I have a field called DateTime??

Ian

Ian


Works here in EDBManager 2.35b3

Try putting DateTime in double quotes

Roy Lambert

Hi Roy,
Well that was interesting.
It didn't work for me.
On a whim I deleted edbmgr.ini and rebuilt the Database connection.
All good now.
Must have picked up some corruption somewhere/sometime.  

Tks for your time & input.
Ian

Ian


I have a small utility I wrote to go through the ini file and delete most of it (leaves session & EDB config information alone). If you want a copy I'll post source & exe to the binaries ng

Roy Lambert

Yes please & thank you.
Ian

Ian


In binaries now as "Ini clean up"

Roy Lambert

Tks Roy,
All good.  Builds & Runs under D11.3.