Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
I try to calculate the difference between two dates with a condition.
If the difference between the date is upper to one year then put the value '>365' else '=<365'.
But the result is no correct.
Below my script and a screenshot of the result:
[DateDiff]:
LOAD DISTINCT
Item,
IF(DATE(DATE#(LastTransDate,'YYYY/MM/DD'),'YYYY/MM/DD')-DATE(DATE#(Ancienne_LastTransDate,'YYYY/MM/DD'),'YYYY/MM/DD')>=365,'>=365','<365') AS YearRatio
RESIDENT CalculationDates;
Please could you tell me what is wrong in my script?
Thank you in advance for your help.
Did Kush's last post help you get things sorted? If so, be sure to circle back to your thread and use the Accept as Solution button on that post to give him credit for the help and to let other Community Members know that worked. If you did something else, consider posting that, and then mark it, so everyone knows what the issue was and what you did to fix it. If you still need further help, leave an update post.
Regards,
Brett