Can anyone convert this to ElevateDB

(IF(_LastAccess IS NOT NULL THEN CURRENT_TIMESTAMP - _LastAccess ELSE 99999.99))  AS _LongAgo,


Roy Lambert

ps

Were intervals invented by the same moron who decided that null <> empty string?

Forgot to sat _LastAttempt is a DateTime field

Roy Lambert

Made it eventually


(IF(_LastAccess IS NOT NULL
THEN CAST(CAST(CURRENT_TIMESTAMP - _LastAccess AS INTERVAL DAY) AS INTEGER)
ELSE 99999))  AS _LongAgo,

A couple of points for anyone else trying this - DON'T use CURRENT_DATE and CURRENT_TIMESTAMP with the wrong field type - these days you get an error.

Personally I don't think you should but you do.

Roy Lambert

Roy,

<< CAST(CAST(CURRENT_TIMESTAMP - _LastAccess AS INTERVAL DAY) AS INTEGER) >>

You don't need to explicitly cast the expression, since the result of
datetime arithmetic is an interval. You just need to specify the type of
interval you want:

CAST((CURRENT_TIMESTAMP - _LastAccess) DAY AS INTEGER)

Ole Willy Tuv

Ole


Thanks - that works well.

Roy Lambert