How to find the Difference between Months of two dates. Eg : 01/01/2017(start date) and Curdate.?
Best Answer
-
Here's a beastmode to calculate the difference in months
period_diff(date_format(`Enddate`, '%Y%m'),date_format(`Startdate`, '%Y%m'))
Just plug in your own date values and you should be good to go.
Let me know if that wasn't what you were looking for.
Sincerely,ValiantSpur
**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.2
Answers
-
There's a beast mode that can do this.
DATEDIFF
Returns the number of days between two dates from datetime values.
DATEDIFF(CURRENT_DATE(), 'lastmoddate')Is that what you're looking for?
Aaron
MajorDomo @ Merit Medical
**Say "Thanks" by clicking the heart in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0 -
Thanks for your reply Aaron, I am looking to calculate age in Months.
Eg: How to calculate the number of months between two Dates.According to Excel formaule= Datdif(Startdate,Enddate+15,"M"), considering the values mentioned above in the question, expected answer is 14 months difference between date 01/01/2017 to todays date(2/26/2018).
Im looking something similar in DOMO.
0 -
Thank you! it just works fine ?
1 -
How do partial months and rounding come in to play for your business?
Is Jan 1 - Feb 28 two months? What about Jan 15 - Feb 14? One month or two?
What about Jan 31 - Mar 1? One month or three?
Aaron
MajorDomo @ Merit Medical
**Say "Thanks" by clicking the heart in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0
Categories
- 10.6K All Categories
- APAC User Group
- 12 Welcome
- 36 Domo News
- 9.6K Using Domo
- 1.9K Dataflows
- 2.4K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 339 Workbench
- 251 Domo Best Practices
- 11 Domo Certification
- 461 Domo Developer
- 47 Domo Everywhere
- 100 Apps
- 703 New to Domo
- 84 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 22 お知らせ
- 62 Kowaza
- 296 仲間に相談
- 649 ひらめき共有