Not a developer, but I am just trying to understan...
# suitescriptl
Luis
10/07/2024, 6:01 AMNot a developer, but I am just trying to understand how dates are formatted in script in the meantime. I would like to retrieve yesterday’s date (Perth, AU timezone).
I have tried this one below, but no luck. Could someone point me to the right direction? Thanks.
var today = new Date();log.debug('today : ', today);var yesterday = new Date(today);yesterday.setDate(today.getDate() - 1);log.debug('yesterday : ', yesterday);var formattedDate = format.format({value: yesterday,type: format.Type.DATE,timezone: format.Timezone.AUSTRALIA_PERTH});log.debug('formattedDate : ', formattedDate);a
apaule
10/07/2024, 8:44 AMI believe the time is pending how you're executing the code. If it is server side you will receive the server time zone. It might be easier for you to just leverage a library that handles the time calculations for you like moment.js
b
battk
10/07/2024, 5:18 PMnetsuite treats dates differently than date and time
battk
10/07/2024, 5:19 PMspecifically, date fields dont actually change depending on timezone, so specifying a timezone for a date does nothing. the date will be formatted in the server's timezone, which will be pacific time
battk
10/07/2024, 5:20 PMdatetimes are the ones where the timezone matter, and its where formatting with N/format will have an effect
l
Luis
10/08/2024, 4:43 PMThanks. What I did then is to convert yesterday’s date (object) in UTC 0 to AUS using this function below. But the result is still incorrect. It’s 17 hours from UTC 0 instead of just 10.
function getYesterdayInAus(yesterday) {
const d = new Date(yesterday);
const localTime = d.getTime();
const localOffset = d.getTimezoneOffset() * 60000;
const utc = localTime + localOffset;
const offset = 10; // disregard DST
const aus = utc + (3600000 * offset);
const yesterdayInAus = new Date(aus);
return yesterdayInAus
}
Luis
10/08/2024, 4:48 PMlooks like it worked when I changed yesterdayInAus to:
const yesterdayInAus = new Date(aus).toLocaleString();
Luis
10/08/2024, 4:53 PMThough I still have to convert it to DD/MM/YYYY format
b
battk
10/08/2024, 4:55 PMstill not sure what you are trying to accomplish
battk
10/08/2024, 4:56 PMDate's on the server are in pacific timezone
battk
10/08/2024, 4:56 PMyesterday in pacific time is not the same as yesterday in australia time
battk
10/08/2024, 4:59 PMthe offsets you give are kinda wrong
battk
10/08/2024, 5:00 PMbut pacific time is currently utc - 7
battk
10/08/2024, 5:01 PMPerth (australian western standard time) is utc + 8
battk
10/08/2024, 5:04 PMthats a 15 hour difference, meaning there are 15 hours of the day where yesterday means a different thing
battk
10/08/2024, 5:06 PMthat actually gets worse due to daylight saving, that 15 hour difference is actually a 16 hour difference half the year since australia doesnt actually observe daylight savings while netsuite will since suitescript follows daylight savings in pacific time
battk
10/08/2024, 5:10 PMin general, if you dont know these things upfront, you need to be using moment timezone to work in different timezones
battk
10/08/2024, 5:27 PMwith that in mind, lets go over the code, im assuming you kept
Copy code
var yesterday = new Date(today);
yesterday.setDate(today.getDate() - 1); Copy code
const d = new Date(yesterday);
const localTime = d.getTime();
const localOffset = d.getTimezoneOffset() * 60000;
const utc = localTime + localOffset; Copy code
const offset = 10; // disregard DST
const aus = utc + (3600000 * offset);
const yesterdayInAus = new Date(aus);battk
10/08/2024, 5:35 PMthat Date is using pacific time, so when you try to convert it back to UTC timezone, thats another 7 hour difference, giving you your observed 14 hour difference
4 Views