Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Difference between dates

Status
Not open for further replies.

mjcmkrsr

Technical User
Nov 30, 2010
828
Hi,

Have you ever wondered in how may years aunt Tilly (well known person in Hacker's Guide) will celebrate her 90th birthday? Or how many days you'll still have to work till your retirement? Or how many WEs you already have gone through?

Comes in this little program (code below).

Enjoy

MarK

Code:
**********
* This app 
* - calculates the total and the sub-total of selected days between two dates
* - diplays the difference between the two dates in words
**********

goForm = CREATEOBJECT("frmForm")
goForm.Visible = .T.
goForm.Show()

READ EVENTS

CLOSE ALL
CLEAR ALL 

RETURN

**********

DEFINE CLASS frmForm as Form

Caption = "Selected days - names - numbers - text"
AutoCenter = .T.
BorderStyle = 2
Width = 570
Height = 330
MinButton = .F.
MaxButton = .F.
Themes = .F.
ShowTips = .T.

	DIMENSION laSelection[7], laTotalDays[1]

	laTotalDays[1] = 0
	
		ADD OBJECT lblSDate as Label WITH Left = 12, Top = 12, Caption = "Start date"
		ADD OBJECT lblEDate as Label WITH Left = 138, Top = 12, Caption = "End date"
		ADD OBJECT lblSDays as Label WITH Left = 12, Top = 72, Autosize = .T., Caption = "Click to select day", ToolTipText = " CTRL / SHIFT Click to multi-select "
		ADD OBJECT lblTSDays as Label WITH Left = 138, Top = 72, Autosize = .T., Caption = "Total of selected days: ", Visible = .F.
		ADD OBJECT lblInWords as Label WITH Left = 12, Top = 294, Autosize = .T., Caption = "Difference in words: ", Visible = .F.
		ADD OBJECT lblNDays as Label WITH Left = 420, Top = 294, Autosize = .T., Caption = "Total Days: ", Visible = .F.

		ADD OBJECT txtSDate as textbox WITH Top = 36, Left = 12, Width = 90, Value = {}
		ADD OBJECT txtEDate as textbox WITH Top = 36, Left = 138 , Width = 90, Value = {}
		ADD OBJECT txtWords as textbox WITH Top = 294, Left = 138, Width = 228, ReadOnly = .T., DisabledBackColor = RGB(0, 240, 240), Visible = .F.
		ADD OBJECT txtNDays as textbox WITH Top = 294, Left = ThisForm.Width - 24 - 60, Width = 60, ReadOnly = .T., DisabledBackColor = RGB(0, 240, 240), Visible = .F.

		ADD OBJECT lstList as ListBox WITH ;
			Top = 96, ;
			Left = 12, ;
			Width = 120, ;
			Height = ThisForm.Height - 24 - 126, ;
			ItemBackColor = RGB(0, 240, 240), ;
			Anchor = 7, ;
			RowSourceType = 1, ;
			RowSource = " Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, Sunday", ;
			ColumnCount = 1, ;
			ColumnWidths = "54, 0", ;
			Multiselect = .T., ;
			ToolTipText = " CTRL / SHIFT Click to multi-select ", ;
			IncrementalSearch = .T.
			
			PROCEDURE lstList.Click()
				FOR lnI = 1 TO This.ListCount
					IF This.Selected(lni)
						ThisForm.laSelection[lni] = ALLTRIM(This.List(lnI, This.BoundColumn))

					ENDIF 
				ENDFOR 
			ENDPROC 
		
		ADD OBJECT cmdDoit as CommandButton WITH Left = 252, Top = 12, Height = 48, Width = ThisForm.Width - 24 - 252, BackColor = RGB(0, 240, 240), ;
								FontBold = .T. , FontSize = 12, Caption = "Calculate", Anchor = 11


			PROCEDURE cmdDoit.Click()
				LOCAL liWeeks, liRDays, liTDays, lcSDay
				
				liWeeks = 0
				liRDays = 0
				liTDays = 0
				lcSDay = ""
				
				IF ThisForm.txtSDate.Value = {} OR ThisForm.txtEDate.Value =  {} OR ThisForm.txtEDate.Value <= ThisForm.txtSDate.Value
					= MESSAGEBOX("Please fill in the dates in correct order", 16, "Choose dates", 3000)

				ELSE 
				
					SET SAFETY OFF  
					ZAP IN csrSelectedDays
					SET SAFETY ON 
					
					FOR i = 1 TO ALEN(ThisForm.laSelection)
						IF VARTYPE(ThisForm.laSelection[i]) = "C"
							INSERT INTO csrSelectedDays VALUES (ThisForm.laSelection[i], 0)

						ENDIF 
					ENDFOR 
				
					IF RECCOUNT("csrSelectedDays") > 0
						liTDays = ThisForm.txtEDate.Value - ThisForm.txtSDate.Value
				
						liWeeks = INT(liTDays / 7)
					
						UPDATE csrSelectedDays SET iDays = liWeeks
					
						liRDays = liTDays - (liWeeks * 7)
					
						FOR i = 0 TO liRDays - 1
							lcSDay = CDOW(ThisForm.txtSDate.Value + (liWeeks * 7) + i)

							IF ASCAN(ThisForm.laSelection, lcSDay) != 0
								UPDATE csrSelectedDays SET iDays = iDays + 1 WHERE cName = lcSDay
						
							ENDIF 
						ENDFOR 
					
					
						ThisForm.txtWords.Value = ThisForm.AMDateDiffAsWords(ThisForm.txtSDate.Value, ThisForm.txtEDate.Value)
						ThisForm.txtNDays.Value = liTDays
											
						SELECT SUM(iDays) FROM csrSelectedDays INTO ARRAY ThisForm.laTotalDays
						
						WITH ThisForm
							.grdSelectedDays.Visible = .T.
							.lblTSDays.Visible = .T.
							.lblInWords.Visible = .T.
							.lblNDays.Visible = .T.
							.txtNDays.Visible = .T.
							.txtWords.Visible = .T.
							.txtNDays.Visible = .T.
						ENDWITH 

						LOCATE 

					ELSE
						WITH ThisForm
							.laTotalDays[1] = 0
							.grdSelectedDays.Visible = .F.
							.lblTSDays.Visible = .F.
							.lblInWords.Visible = .F.
							.lblNDays.Visible = .F.
							.txtNDays.Visible = .F.
							.txtWords.Visible = .F.
							.txtNDays.Visible = .F.
						ENDWITH 
						
						 = MESSAGEBOX("Please choose at least one day", 64, "Choose days", 3000)

					ENDIF 

					FOR i = 1 TO ALEN( ThisForm.laSelection)
						ThisForm.laSelection[i] = .F.
					Endfor

					WITH ThisForm
						.lstList.Clear()
						.lstList.Requery()
						.lblTSDays.Caption = "Total of selected days (" + TRANSFORM(ThisForm.txtEDate.Value) + " excluded) : " + TRANSFORM(ThisForm.laTotalDays[1])
						.Refresh()
					ENDWITH 
				ENDIF 
			ENDPROC 
		
		ADD OBJECT grdSelectedDays AS Grid WITH ;
			RecordSource = "csrSelectedDays", ;
			ColumnCount = -1 , ;
			Left = 138, ;
			Top = 96, ;
			Width = ThisForm.Width - 24 - 138, ;
			Height = ThisForm.Height - 24 - 126, ;
			BackColor = RGB(0, 240, 240), ;
			DeleteMark = .F. , ;
			Enabled = .F. , ;
			Anchor = 15, ;
			Visible = .F.
	 
			PROCEDURE grdSelectedDays.Init
				 WITH This.Column1
				  .Width = 78			
				  .Header1.Caption = "Day"
				 ENDWITH

				 WITH This.Column2
				  .Width = 60			
				  .Header1.Caption = "Number"
				 ENDWITH

			 ENDPROC 
			 
	PROCEDURE Load()
		CREATE CURSOR csrSelectedDays (cName C(18), iDays I)
		
	ENDPROC 
      
	PROCEDURE Destroy()
		CLEAR EVENTS
	
	ENDPROC 
	
	FUNCTION AMDateDiffAsWords
		*!*	written by MarK - credit to Andrew Mozley

		LPARAMETERS  tdSDate, tdEDate

		LOCAL ldEofMonth as Date, ;
				liTotalMonths as Integer, ;
				liYears as Integer, ;
				liMonths as Integer, ;
				liWeeks as Integer, ;
				liDays as Integer, ;
				lcAnswer as Character
				 
				ldEndOfMonth = {}
				liTotalMonths = 0
				liYears = 0
				liMonths = 0
				liWeeks = 0
				liDays = 0
				lcAnswer = ""  

		*!*	If Day(tdSDate) > Day(tdEDate), we calculate the number of days remaining in the 
		*!*	start month (may be zero) and add it to the number of days in the end date

		IF DAY(tdSDate) > DAY(tdEDate)
			ldEofMonth = GoMonth(tdSDate,1) - Day(GoMonth(tdSDate,1))
			liDays = DAY(tdEDate) + (ldEofMonth - tdSDate)

		ELSE
			liDays = DAY(tdEDate) - DAY(tdSDate)
	
		ENDIF
			
		*!*	Now the total number of months

		liTotalMonths = MONTH(tdEDate) - MONTH(tdSDate) + (12 * (YEAR(tdEDate) - YEAR(tdSDate))) - IIF(DAY(tdSDate) > DAY(tdEDate), 1, 0)
		liYears = INT(liTotalMonths / 12)
		liMonths = liTotalMonths - (liYears * 12)
		liWeeks = INT(liDays / 7)
		liDays = liDays - (7 * liWeeks)
		   
		*!*	And format the answer as text

		lcAnswer = ""

		IF liYears > 0
			lcAnswer = ALLTRIM(STR(liYears)+ " Year" + IIF(liYears > 1,"s",""))
		ENDIF

		IF liMonths > 0
			lcAnswer = lcAnswer +" "+ ALLTRIM(STR(liMonths))+" Month"+ IIF(liMonths > 1,"s","")
		ENDIF

		IF liWeeks > 0
			lcAnswer = lcAnswer +" "+ ALLTRIM(STR(liWeeks)) +" Week"+ IIF(liWeeks > 1,"s","")
		ENDIF
		
		IF liDays > 0
			lcAnswer = lcAnswer +" "+ ALLTRIM(STR(liDays))+" Day"+ IIF(liDays > 1,"s","")
		ENDIF
		
		RETURN lcAnswer
ENDDEFINE 
**********
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top