Expression Simplification

[rxp03570]

Hi,

Is there anyway to simplify this expression I'm using?.

Date(AddMonths(Date(Max(Date#(ATTRIBUTE2, 'MMM-YYYY')),'MMM-YYYY'),-1),'MMM-YYYY')

Thanks,

[Nicole-Smith · Accepted solution]

You can get rid of one of the Date() functions because your Date# has already told QS that it is a date:

Date(AddMonths(Max(Date#(ATTRIBUTE2, 'MMM-YYYY')),-1),'MMM-YYYY')