Month Function

[#1]

Hi all,

This is what I am trying to write in QV.

IF Sale Date MONTH = LAST MONTH

Return 'Value1'

ELSE 'Value2' AS [This Month]

LOAD

[Client],
[Sale  Date],
IF( MONTH([Sale Date]) = MONTH()-1,'Value1,'Value2')AS [This Month],

FROM
[..\..\Data\DataSheel.xlsx]
(ooxml, embedded labels, table is Sheet1);

Please kindly assist.

Thank you.

[#2]

Hi Marco,

Massimo, Anand and your suggestions have been very helpful. I have marked Anand and yours. I am happy to mark Massimo but it is seem the option is not there on Massimo's windows.

Regards

[#3]

Please how do I give points? I am happy to..