comparing month year between two dates

[srikantj]

hi

I have two dates

date1          date2

4/24/2016    5/14/2017

3/30/2017    6/17/2015

.

.

i want to compare  month year of date1 =  month year of date 2

and quarter year of date 1 = quarter year of date 2

Qliksss suggest

[tripatirao]

Hi,

Can you please elaborate with example what u want.

Regards

[srikantj]

There are two date fields

i just want to compare month year of one date to month year of another date

if(4/2016=5/2017, 1,0)

[tresesco]

May be like this?

InMonth(Date1, Date2, 0)

InQuarter(Date1, Date2,0)

[dsharmaqv]

Extract month and year for both fields

Month(date1)

Year(date1)

Month(date2)

Year(date2)

Now you can compare these derieved fields

incase you need month year then concatenate both fields

Date#(Month(date1)&', '&Year(date1) ,'MMM, YYYY') as Month_Year1

Date#(Month(date2)&', '&Year(date2),'MMM, YYYY') as Month_Year2

[srikantj]

But i want to give expression if equals quantity  not true or false

[srikantj]

i know this way but i want simple way

as i need to write other expressions based on that

[tresesco]

InMonth()/InQuarter() themselves return true or false. You can try like:  =If( InMonth(Date1,Date2,0), 'true', 'false')

[dsharmaqv]

what do you want to do exactly ?

[srikantj]

if(quarter year date1=quarter year date 2,quantity,0)

is there any pre defined function??????