please help me to Modify this script
*This post is locked for comments
I've never used POS 2009, and there's probably a much more elegant way to do this, but the easiest way to get one day before what its currently returning would be to replace
DATEADD(WK, DATEDIFF(WK, 0, @inputDate), -1)
with
DATEADD (DAY, -1, DATEADD(WK, DATEDIFF(WK, 0, @inputDate), -1))
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,802 Super User 2024 Season 2
Martin Dráb 229,129 Most Valuable Professional
nmaenpaa 101,154