655
Hi,
I'm trying to create a SmartList by looking a the manufactuirng table BM010415 field CHANGEDATE_I.
I want to know if a new BOM has been created based on the day prior to CHANGEDATE_I.
I'm not clear on what the WHEN and ELSE expression should be.
CASE BM010415_{BOM Revision:Change Date} >= DATEADD(DAY, -1,getdate())
WHEN when_expression THEN result_expression
ELSE else_result_expression
Thanks.
*This post is locked for comments
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (