function for getting date part only of a datetime and difference between two dates NOT using "dy" function

[JozefAerts]

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

[eljanssens]

Hi Jozef. I think this is a bit to complex to solve with existing stuff. You can create a ticket for this in the engine repo but note that development focus is now on v1.0.