Date subtraction

MarkTash — Sat, 16 Nov 2024 21:19:29 GMT

=if(Dimensionality()=max(Dimensionality()),

if(Count({<[Transactions.Txn Type]={"Invoice"},Transactions.Pending={0},[Transactions.Txn Date]={">=$(=YearStart(vDate))"}>} DISTINCT [Transactions.Txn ID])>0,

If(Count({<[Transactions.Txn Type]={"Invoice"},Transactions.Pending={0},[Transactions.Txn Date]={"<=$(=YearEnd(vDate,-1))"}>}
DISTINCT [Transactions.Txn ID])=0,

'New',

'Current'),

if(Count({<[Transactions.Txn Type]={"Invoice"},Transactions.Pending={0},[Transactions.Txn Date]={"<=$(=YearEnd(vDate,-1))"} >}
DISTINCT [Transactions.Txn ID])>0,

'Lost',

'Never Ordered')))

In the enclosed Formula I have been able see if the Year Value is less by 1 year, but what i really want is to see if the change in one year by date not year from the transaction date so so 3/28/2018 to make sure it is 3/30/2017 is still Under year were 3/27/2017 is not.

topic Date subtraction in App Development

Date subtraction