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

Hello all.  I'm getting a Unix Timestamp from an API that I need to set the `trandate` of a timebill with in NetSuite.  All sorts of things come into play (server timezone, user pref timezone, etc).  Any guidance on how to get this right.  Its for a SuiteApp, is I need to ensure the solution is universal

My thought is to leverage suiteQL in some way to convert the timestamp into a date object.

I'm thinking if I using the
```runtime.getCurrentUser();```
This would help me identify if I should use the system timezone or the users timezone.

currently, I'm setting the `trandate` to new Date( `unix_timestmap` * 1000)

You might take a look at the momentjs library. We use it in our SuiteScripts for some more complex conversions like this. <https://momentjs.com/>

The unix timestamp is UTC. But, it sounds like you are wanting to convert that to the user’s local timezone.

use the <https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/Date/Date|Date> constructor to convert the timestamp into Date in the server's timezone (which will be pacific)

then use <https://system.netsuite.com/app/help/helpcenter.nl?fid=section_4388843892.html|format.format> to make a date time string
the string will be in the current's users date time format, so you discard the time and use <https://system.netsuite.com/app/help/helpcenter.nl?fid=section_4273157034.html|Record.setText>

I tend to try and standardize on UTC if possible (and a unix timestamp should be UTC) .. then translate that to whatever timezone representations are useful as needed.