Formula value to return current date and time

AI generated answer (using internal Slack threads):

In NetSuite, you can use the

{today}

or

SYSDATE

formula to return the current date. However, please note that

{today}

returns the date in the user's timezone, while

SYSDATE

returns the date in the server's timezone (Pacific Time). For the current time, NetSuite does not have a direct formula. But you can create a custom field and use a formula to calculate the current time based on the

{today}

or

SYSDATE

formula. Here are some examples of how you can use these formulas: - To calculate the difference between the current date and the date a record was created, you can use the formula

({today} - {datecreated}) * 24 > 1

. This formula calculates the difference in hours. - To calculate the difference between the current date and a transaction date, you can use the formula

{today}-{trandate}

. - To track time intervals with case reporting, you can use a formula like

ROUND((CAST({custevent_date_case_reached_queue} AS DATE) - {date}) * 24 *60, 1)

. This formula calculates the difference in minutes. Please note that these formulas are used in the context of saved searches or scripts in NetSuite. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******