Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
URGENT, PLEASE HELP - How to change the format of the date?
Hi everyone, I am using the following formula within an email.
<%=decode(to_number({custitem_weekavailable}),0,{today},to_date(to_number({custitem_weekavailable})* 7-6,'DDD'))%>
This formula pulls in the "week number" which we set on each item record "Its a list of numbers where we select one" and tranforms that into a date.
It pulls in the date in the format 2010-08-31.
I need that date to display in the english format of 31-08-2010.
Anyone got any ideas?
Thanks for your help!
0