Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- case(YEAR(CloseDate),
- YEAR(Today()),1,
- YEAR(Today())-1,IF(CloseDate <= date(year(Today())-1,month(Today()),day(Today())),1 , null),
- Null
- )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement