Compare two Dates

Understanding basics of 1C:Enterprise platform. To start working with 1C:Enterprise platform visit Getting started page

Pages: 1

sarah carrey	#1 People who like this:0 Yes/0 No Dec 20, 2011 08:20 AM
Active user Rating: 4 Joined: Sep 16, 2011 Company: Oksley Shipping	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.

Evgeny Cherkasov	#2 People who like this:0 Yes/0 No Dec 20, 2011 09:02 AM
Just came Rating: 1 Joined: Dec 6, 2011 Company:	12 * (Year(Date2) - Year(Date1)) + Month(Date2) - Month(Date1) Also in query you can use DATEDIFF(Date1, Date2, MONTH)

Silvia Ashley	#3 People who like this:0 Yes/0 No Dec 21, 2011 01:55 PM
Active user Rating: 6 Joined: Sep 16, 2011 Company: TLG Integration	Super, Evgeny! Thank you!

sarah carrey	#4 People who like this:0 Yes/0 No Dec 21, 2011 02:49 PM
Active user Rating: 4 Joined: Sep 16, 2011 Company: Oksley Shipping	Yes, that helped, thank you!

Evgeny Cherkasov	#5 People who like this:0 Yes/0 No Dec 23, 2011 06:48 PM
Just came Rating: 1 Joined: Dec 6, 2011 Company:	You are welcome )

Subscribe

Pages: 1

Users browsing this topic (guests: 1, registered: 0, hidden: 0)