This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Ok so I'm seeing some weird behavior that has me stumped. I thought adding or subtracting 2 datetime fields in a saved search gives you a decimal ( I want to be able to say that an hour has passed, so {now} - {otherdatetime} )

However no matter what I do the search renders the value as some weird date time that looks like this `+0000000004:38:35.000000` and won't let me do the logic I need. What am I missing ? 

in sql the difference between 2 timestamps is an interval

the difference between 2 dates is a number

either <https://docs.oracle.com/cd/B19306_01/server.102/b14200/functions016.htm|cast >your timestamp as a date or use <https://docs.oracle.com/cd/B19306_01/server.102/b14200/functions183.htm|toDate>

i didnt think netsuite supported cast, generally i wouldnt ask for this but assuming {now} and {otherdatetime} are my 2 datetime fields, can you maybe help with a sample saved search formula?

nevermind the cast seemed to have worked actually? :joy: