Hey,
Firstly, thank you for your help.
I've made several attemps with DADIF, trying to create another calculate item (in Information maps because that's where my client asks caculated items to be created), but I failed miserably because my expressions don't pass validation.
Also, I checked https://documentation.sas.com/doc/en/vdmmlcdc/8.1/lefunctionsref/p1gz65986b9jqin19zk9xqbi7ns3.htm and I didn't see 'Actual' as a possible inserted parameter, though It does appear in a code example but that's outside of CIS as far as I know. ACT/ACT seems related to this topic.
A bit more info that might help:
X is a field in table A with date format 2013-07-24
Y is a field in table B with date format 2013-07-24 (same format)
Perhaps it is not possible to use two fields from two different tables?
Here are some of my attempted expressions for DATDIFF(Y,X,'Actual'):
DATDIF(DATEPART(<<A.X>>),DATEPART(<<B.Y>>),'ACT/ACT')
DATDIF(DATEPART(<<A.X>>),DATEPART(<<B.Y>>),'Actual') DATDIF(<<A.X>>,<<B.Y>>,'ACT/ACT') DATDIF(<<A.X>>,<<B.Y>>,'Actual')
DATDIF(<<'2021-07-07'>>,<<'2021-08-08'>>,'ACT/ACT') DATDIF(<<'2021-07-07'>>,<<'2021-08-08'>>,'Actual')
... View more
