- Log in to post comments
User bio
404 bio not found
Member since Jan 29, 2018
Posts:
Timo has not published any posts yet.
Replies:
Just short comment, not sure why you need to call sql date_add function?
Your SelectTermination takes a parameter as %DateTime. I would just use simple $H as current date/time then subtract DaysBack back.
e.g.
set tDate=+$H-..#DaysBack
- Log in to post comments
Hi Norman,
could you modify foo and do something like this at its beginning?
If $data(^SpecialcaseFlag) {
// get last entry
set idx=$order(ITEMS(""),-1)
// set new last entry
set idx=idx_"z"
set ITEMS(idx)=......
}
- Log in to post comments
Certifications & Credly badges:
Followers:
Following:
Timo has not followed anybody yet.
Hi Alexandra,
you might want to review the documentation on SQL Performance best practises first: doco