in suiteql how do i calculate the number of minutes between sysdate and a datetime field

AI generated answer (using internal Slack threads):

In SuiteQL, to calculate the number of minutes between the current system date (

SYSDATE

) and a datetime field, you can use the following formula:

ROUND((SYSDATE - to_date(to_char({YourDateTimeFieldName},'DD.MM.YYYY HH24:MI'),'DD.MM.YYYY HH24:MI'))*1440)

This formula calculates the difference between the current system date and the datetime field, and then multiplies the result by 1440 to convert the difference into minutes. Please replace

{YourDateTimeFieldName}

with the actual name of your datetime field. Also, note that the

0.3333

value in the formula is a timezone offset from

SYSDATE

. This value may need to be adjusted if you're in a daylight savings area. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******