Discussion board where members can get started with Qlik Sense.
i have a following case, i have 2 Fields: From Date and To Date,
if i use this procedure :
Date(Date#(From_Date, 'DD.MM.YYYY'))as From_Date,
Date(Date#(To_Date, 'DD.MM.YYYY'))as To_Date,
Num(To_Date) - Num (From_Date), so i can calcualte the Difference in Days, and it does work great
06.10.2017 06.05.2019 > How can i calculate in this case the Difference in months
Thanks a lot for any feedback and help
Go to Solution.
i think you should look into this solution which is interesting too and try to replicate that in your app.
How Do I Get the Number of Months Between Two Dates?
date_diff --->Num(To_Date) - Num (From_Date)
you can divide your date_diff/12 and ceil(date_diff/12),floor(date_diff/12) depending upon you want to include the current month or not.
thanks a lot for your responce, but i dont understand this procedure, the funct: datediff i can normally use in excell but not in Qlik Sense
Thanks a lot
Prodosh Mate, thanks a lot for your responce and helps, it does work
have a nice day
This Issue is solved, Solution can be found here: Difference in Month