Forum Stats

  • 3,686,737 Users
  • 61,104 Discussions
  • 206,419 Comments

Discussions

Check out Oracle NetSuite upcoming events and conferences here
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now!
RUN, DON’T WALK...Registration for #SuiteWorld 2022 is officially OPEN! This special early bird price won’t last long, so make sure you don’t miss out: https://lnkd.in/gGRN78A3
Virtual Event: Getting the Most Out of NetSuite Standard Costing Capabilities

You asked for it, you got it! Join the webinar Getting the Most out of NetSuite Standard Costing Capabilities on June 28, 2022 at 11AM PT. Register here!

how to change a date in a Workflow to Set Field Value to specific date each month

edited Jul 29, 2021 1:03AM in Ask A Guru 5 comments

I am trying to change Expected Close Date on an Opportunity to the 23rd of each month.

I tried this but it's not working:

DATEDIFF (dd , -7 , LAST_DAY(month) )

Was I close? I know nothing about SQL but what Iearned in SuiteFlow courses and SuiteAnswers, so far. Any suggestions are appreciated.

Thanks, Jim

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!

Leaderboard

This Week's Leaders

Leaders not available
More...

This Month's Leaders

All Time Leaders