Desktop version

Main > Forum > 1C:Enterprise Platform > Studying 1C:Enterprise platform > Compare two Dates

Forum

Search UsersRules
Compare two Dates
sarah carrey
#1
Dec 20, 2011 08:20 AM
Active user
Points:: 0
Joined:: Sep 16, 2011

There are two dates: 07/25/2010 and 12/30/2011. I need to find out what is the difference between those dates in months.
Profile
Evgeny Cherkasov
#2
Dec 20, 2011 09:02 AM
Just came
Points:: 9
Joined:: Dec 6, 2011

12 * (Year(Date2) - Year(Date1)) + Month(Date2) - Month(Date1)

Also in query you can use DATEDIFF(Date1, Date2, MONTH)
Profile
Silvia Ashley
#3
Dec 21, 2011 01:55 PM
Active user
Points:: 3
Joined:: Sep 16, 2011

Super, Evgeny! Thank you!
Profile
sarah carrey
#4
Dec 21, 2011 02:49 PM
Active user
Points:: 0
Joined:: Sep 16, 2011

Yes, that helped, thank you!
Profile
Evgeny Cherkasov
#5
Dec 23, 2011 06:48 PM
Just came
Points:: 9
Joined:: Dec 6, 2011

You are welcome )
Profile
Subscribe
Users browsing this topic (guests: 1, registered: 0, hidden: 0)



© 1C LLC. All rights reserved
1C Company respects the privacy of our customers and visitors
to our Web-site.