Forum Stats

  • 3,679,580 Users
  • 57,523 Discussions
  • 190,817 Comments

Discussions

Check out Oracle NetSuite upcoming events and conferences here
NetSuite Maintenance - September 25
Please note that on Saturday, September 25, 2021, at 10:00 PM Pacific time, our Case Management System will undergo a scheduled maintenance for approximately 180 minutes. During this time, case creation via SuiteAnswers will be unavailable and inbound calls will be routed to Customer Service.
Cheers to 1️⃣0️⃣ years of #SuiteWorld! 🎉 We’re celebrating by extending the Super Saver Pass AND launching the digital On Air experience TODAY! Whether you join us in-person or digitally, we can’t wait to make even more memories with you. https://lnkd.in/dGpPpmUV
Webinar | COSTING 101: Learning the Basics of Inventory Costing webinar was a success! Please take a minute to fill out this short survey. For those who missed it - Don't worry! Here's the link to the recorded session!
NetSuite Support Assistant: A quicker way to get answers to your basic NetSuite questions
The NetSuite Support Assistant is a convenient chatbot SuiteApp that provides quick responses to your basic questions directly from your NetSuite Account.
Click NetSuite Support Assistant Now Available for more details.
Release Preview 2021.2

If you would like to receive a 2021.2 Release Preview account, please opt -in to take advantage of the Release Preview access period to prepare and become familiar with the new NetSuite capabilities. For details, see Requesting a Release Preview Account.

If you receive a Release Preview account in 2021.2, you can access it several weeks before your production account is scheduled for an upgrade to the new release of NetSuite. Notifications with details about Release Preview availability are sent to the account administrators as described in Release Preview Notifications. Release Preview availability information is also posted on the New Release portlet.

Expose Today's Date in Dataset Formula in SuiteAnalytics Workbook

Irene Gal-Oracle
Irene Gal-Oracle Member, ORACLE_EMPLOYEE Posts: 2 Green Ribbon

In standard saved search we can expose today's date by using {today}.

When using same syntax in Dataset formula though, Im getting an error that says "your formula contains a reference to an inaccessible field."

{Current Date} does not work either.

Thoughts?

Answers

  • Emilia Ironov-Oracle
    Emilia Ironov-Oracle Member, forum_netsuite_mod, ORACLE_EMPLOYEE Posts: 703 Gold Trophy

    Hi Irene,


    Thank you for creating this thread!  

    Please allow our gurus/members to look into this and update you for any findings. 

    We will get back to you as soon as possible!  

     

    Anyone else who has an insight? Feel free to reply to this thread! 

    Kind regards,

    Emilia Ironov - Oracle | Ask a Guru

  • Dominica Sevilla-Oracle
    Dominica Sevilla-Oracle Member, forum_netsuite_mod, ORACLE_EMPLOYEE Posts: 364 Bronze Trophy

    Hello Irene,

    Good day! Hope you are well. 😊

    Instead of {CURRENT DATE}, can you try using {CURRENT_DATE}?

    Let us know if the one with underscore works on your end. Thank you! 😊

    -------------

    If you find this reply to your question as helpful, others with the same question might find it helpful as well. By marking “Yes” on the “Did this answer your question?”, you’ll be able to aid the community to find the solution much easier and faster without the need to read through all the replies.


    Dominica Sevilla - Oracle | Ask a Guru

  • Dominica Sevilla-Oracle
    Dominica Sevilla-Oracle Member, forum_netsuite_mod, ORACLE_EMPLOYEE Posts: 364 Bronze Trophy

    Hello Irene,


    Good day! Hope you are well. 😊


    I would just like to follow up on this concern. Can you confirm if using {CURRENT_DATE} instead of {CURRENT DATE} worked on your end?


    Your feedback are highly appreciated. By marking “Yes” on the “Did this answer your question?” if you find the comment/s helpful, you’ll be able to aid the community to find the solution much easier and faster without the need to read through all the replies. Thank you so much! 😊


    Dominica Sevilla - Oracle | Ask a Guru