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.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
SQL Essentials: NEXT_DAY Function Explained
Overview
The NEXT_DAY function returns the date of the first specified day of the week that occurs after a given date. In simpler terms, it helps you find the next occurrence of a particular day of the week following a specific date.
For example, if today is Monday and you want to find the date of the next Friday, the NEXT_DAY function can provide that information.
Understanding the Syntax
The syntax for the NEXT_DAY function is:
NEXT_DAY(date, day of the week)
- date: The starting date from which you want to find the next specified day of the week.
Learn how to Refer A Member | Earn the Answer Accepter Badge | Be the Content Creator of the Quarter | Vote for the content you want to see!
Tagged:
0