Issue with previous month and date formatting and math

[#1]

Any idea why the following occurs?

Expression1 (works):

Sum({$<[Time.Month ID] ={$(=Date(Max([Order.Receive Date]), 'YYYYMM'))}>} [Order.Request Value]) --returns 201008

Expression 2 (doesn't work: trying to figure out sntax to return 201007):

Sum({$<[Time.Month ID] ={$(=Date(Max([Order.Receive Date]), 'YYYYMM')-1)}>} [Order.Request Value]) -returns 40394

Any help would be appreciated!

Thanks,

Dan

[spsrk_84 · Accepted solution]

Hi,

I tried in another way to get the required o/p

=

Date(AddMonths((TODAY()),0),'YYYYMM') IT returns 201008

=

Date(AddMonths((TODAY()),-1),'YYYYMM') It RETURNS 201007

I think u need to implement the same sort of logic to get the desired output in your case..

Check in this way Hope it works...........

Cheers

Ajay