I’m trying to rewrite an existing saved search int...
# suitescriptj
jen
03/05/2021, 9:50 PMI’m trying to rewrite an existing saved search into SuiteQL. One of the columns compares a custom field (of time Date/Time) with the current time, and provides the difference in seconds. Here’s the formula as it appears in the Saved Search
Copy code
((CAST(current_timestamp AS DATE) - CAST({custrecord_check_datetime} AS DATE)) * 86400b
burkybang
03/05/2021, 9:54 PMYou have an extra leading parenthesis here. Not sure if that's the issue.
j
jen
03/05/2021, 9:55 PMthat one’s not the problem
jen
03/05/2021, 9:55 PMsorry should have been
Copy code
(CAST(current_timestamp AS DATE) - CAST({custrecord_check_datetime} AS DATE)) * 86400jen
03/05/2021, 9:56 PMit’s the SuiteQL version that fails
w
Watz
03/05/2021, 10:15 PMwiiiieeerd
Watz
03/05/2021, 10:15 PM(current_timestamp - trandate) *24*60*60
Watz
03/05/2021, 10:15 PMthat calculation works (but the display of it is not in seconds)
Watz
03/05/2021, 10:16 PMbut not (current_timestamp - trandate)*86400
Watz
03/05/2021, 10:17 PMIt seems as it can't multiply with a large number if it reaches a certain number within that calculation-step??
I had 2021-03-03 as trandate, and at first I could multiply by 25670 but each second I had to lower that number.
But splitting it up into 24*60*60 still works.
j
jen
03/05/2021, 10:25 PMwhat the hell
jen
03/05/2021, 10:25 PMthat’s peculiar AF
jen
03/05/2021, 10:25 PMit’s only kinda-sorta giving me a sensible result