Is my below if condition proper?
I think m doing some mistake in 'and'!
Can anyone correct this condition?
IF(date1- date2 <= 30, 'Less Than 30',
IF(date1- date2 > 30 AND date1- date2 <= 45, 'Grace period',
if((date1- date2 >45,'Outside grace period'))) as Range_values ;
Looks right but can be shortened to this may be
IF(date1- date2 <= 45, 'Grace period', 'Outside grace period')) as Range_values ;
remove the extra '(' in the last line rest everything seems correct
Thankyou Sunny T and Aar Kay , both conditions are working.
Retrieving data ...