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

Hey everyone, Is there a way to change the week #s in netsuite?  Right now TO_CHAR({trandate},'WW')  is week 1 yesterday, but week 2 today.  I imagine that's because the year started on a Friday.  I would love for the first Sunday-Saturday to be considered the same week.  Any ideas?  Thanks

I feel like this is a defect...my system preferences says the first day of the week is Sunday.  Why would Friday start week 2 for me???

can override by user prferences, but i don't have anything different at the user level either.  Oh netsuite....

ahhhhh to_char with IW does what I want it to do...ignore me :slightly_smiling_face:

thanks <@UMF86VAV8> where were you 30 minutes ago lol...definitely took me too long to figure that out, but thanks!