TO_CHAR({today},'YYYY-MM-DD') || ' ' || TO_CHAR({now},'HH24MISS') in correct

AI generated answer (using internal Slack threads):

Based on the conversations, it seems like there are several discussions about the usage of the

TO_CHAR()

function in NetSuite. In the first thread, the user was trying to convert the current date to a number using

TO_NUMBER(TO_CHAR({today},'YYYY'))

. They initially encountered an error because they were using

Formula (Text)

instead of

Formula (Numeric)

. The correct usage should be

Formula (Numeric): TO_NUMBER(TO_CHAR({today},'YYYY'))

. In the second thread, the users were discussing how to return a value based on the current day of the week. They found that

TO_CHAR()

returns the day name in uppercase and the case of 'Day/day/DAY' determines the

TO_CHAR

case output in Oracle. They also found that

TO_CHAR

adds trailing spaces, which can be removed using

replace(to_char({today},'Day'),' ','')

. In the third thread, the user was trying to get transactions that were shipped yesterday, but if it's Monday, they wanted to get transactions for last Friday. They used a case statement with

TO_CHAR ({TRANDATE}, 'DAY')

to check if the current day is Monday and then adjusted the

TRANDATE

accordingly. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******