Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
Saved Search CSV Export Strips Leading Zero
I have a scheduled saved search that emails a csv version of the results. Included in the results is a date field in MMDDYY format using a Formula (Text) of "TO_CHAR({trandate},'MMDDYY')". It works fine.
However, in the resulting csv file the leading zero of the MM is stripped. I understand that I can manually change the format of that column in Excel but this is an automated email of the created csv file.
Is there a way to have this column act like text and leave the full 6-digit date including the leading zero?
Thanks for any help you can provide.