Date Calculation

KevinJ — Fri, 15 Nov 2024 20:57:05 GMT

I have this existing expression

round(Avg({<[Item Type]={'Inventory Item','Inventory Cebu'}>}Aggr(Date([Order Date1],'DD/MM/YYYY') - date([Approved Date],'DD/MM/YYYY'),

[Purchase Order No.],ShipID)))

I want to add that if Date([Order Date1],'DD/MM/YYYY') - date([Approved Date],'DD/MM/YYYY') is negative it would use Order Date 2.

And also if Date([Order Date1],'DD/MM/YYYY') - date([Approved Date],'DD/MM/YYYY') is negative and also Order date 2 is null it will not add up to the round(avg).

Re: Date Calculation

marcus_sommer — Tue, 04 Jun 2024 15:31:22 GMT

If you want to add such conditions you will need some simple but probably nested if-loops, like:

... if(DateZ = null(), null(), if(DateX - DateY < 0, DateZ - DateY, DateX - DateY)) ...

topic Re: Date Calculation in App Development

Date Calculation

Re: Date Calculation