Discussion board where members can get started with QlikView.
Please help me......
i need to get a difference of two dates from SAP Data. columns are posting date and document date.
the condition should be if posting date - document date is <= 5 it is not violated if more than 5 its violated.
the date format is like this DD.MM.YYYY
Go to Solution.
You can try something like this:
Hope this helps.
Try to use this format
if((OrdDate-OmDelDt) <= 0, (OrdDate-OmDelDt),(OrdDate-OmDelDt)) as Ontime
If you wants to change the date format use this expression :
Date(OmExpDelDt,'DD/MM/YYYY') AS OmExpDelDt
and the syntax format of if is following :
if(condition , then , else)
You may try