select date part (first 10 characters) of date (e.g. --ENDTC) and subtract two dates from another #1735
Unanswered
JozefAerts
asked this question in
Q&A
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
-
For SEND-(DART-)406, I need to take the earliest date from SJ.SJSTDTC, so I use "min_date", but then I may only use the date part (first 10 characters), and then subtract 2 such dates from each other. I can however not use the "dy" method, as that is specific for DM-RFSTDTC which excludes "0". So I need to have the "real" (not-FDA-method) difference.
I did sofar not find any operators for this.
How do I get the first 10 characters? Is there something like a "substring" operation?
Is there an operation like "datediff" that provides the "real" (not-FDA-method) difference?
Many thanks in advance,
Jozef
Beta Was this translation helpful? Give feedback.
All reactions