Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need to compare the current month data for a particular Date with previous month data for same date, If there is no data on the same Date of previous month i have to compare with two days back data (N-2) Date... Can any one help me ..
I have sales data for today, i have to compare the previous month sales data with same date, if i doesn't have sold on that day i have to compare with previous day or day before. Date = 15/01/2019 comparing Date= 15/12/2018 If i have no sales on 15/12/2018 , i have to compare with 14/12/2018 or 13/12/2018
Please provide a sample and expected output to help you better here
I have sales data for today, i have to compare the previous month sales data with same date, if i doesn't have sold on that day i have to compare with previous day or day before. Date = 15/01/2019 comparing Date= 15/12/2018 If i have no sales on 15/12/2018 , i have to compare with 14/12/2018 or 13/12/2018