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

anyone know how to convert a date/time result in a saved search to all minutes or seconds using a formula?

You mean like getting the epoch time? Something like:

`{datetimefiels}-to_date('1-1-1970 00:00:00','MM-DD-YYYY HH24:Mi:SS'))*24*3600`

<@UBRE35B6K> i'm seeing that the parenthesis don't balance on that one

but basically, i'm trying to compare two date/time values

Oops. I must have missed it in my copy paste...

`({datetimefiels}-to_date('1-1-1970 00:00:00','MM-DD-YYYY HH24:Mi:SS'))*24*3600`

and of course datetimefiels should be called datetimefield, but I don't know what datetime field you're using. Replace it with your field name.

I think you should be able to compare two date time fields with something like:

`CASE`
  `WHEN {datetime1} &gt; {datetime2}`
  `THEN 1`
  `ELSE 0`
`END`

Then put that as a formula into your criteria. Of course, I may not know your exact use case.

you may have better luck simply subtracting the two columns from each other

`{datetime1} - {datetime2}`  should give a difference in days which you should be able to convert to your desired units

if the result is a weird looking interval, you should cast the timestamps to date

`CAST ({datetime1} AS DATE) - CAST ({datetime2} AS DATE)`

thanks <@UBRE35B6K> and <@U5TF1GQ20> yes with some testing i got it figured out.