"SELECT * FROM Actions_OPE WHERE TimeStmp Between #" & DateDeb & "# " & _ " And #" & DateFin & "#"Il te faudra peut-être avoir recours à Format pour changer le format de tes dates au format US : MM/DD/YYYY
Public Sub Action_Bouton() Dim cn As ADODB.Connection 'Utiliser la référence Microsoft ActiveX Data Objects 2.8 Library ainsi que OLE automation' Dim rs As ADODB.Recordset Dim i As Integer Dim j As Integer Dim champ0 As String Dim champ1 As String Dim champ2 As String Dim reponse As String Dim DateDeb As Date Dim DateDebUTC As Date 'La BDD est en UTC donc la requête doit être en UTC' Dim DateFin As Date Dim DateFinUTC As Date Dim UtcDateTime As Date Dim TempsLocal As Date Range("A:A,B:B,C:C").ClearContents 'début enregistrement macro' Range("B11").Select ActiveCell.FormulaR1C1 = "Date/Heure" Range("C11").Select ActiveCell.FormulaR1C1 = "Message" Range("D11").Select ActiveCell.FormulaR1C1 = "Utilisateur" Range("E11").Select ActiveCell.FormulaR1C1 = "FP" Range("F11").Select ActiveCell.FormulaR1C1 = "N°OF" 'fin enregistrement macro' DateDeb = Format(Feuil1.DTPicker1.Value, "dd/mm/yyyy hh:mm") 'Association DateDeb à la valeur du calendar1' 'DateDebUTC = ConvertLocalTimeToUtcTime(DateDeb) Fonction LocalTime -> UTC' DateFin = Format(Feuil1.DTPicker2.Value, "dd/mm/yyyy hh:mm") 'Association DateFin à la valeur du calendar2' 'DateFinUTC = ConvertLocalTimeToUtcTime(DateFin) Fonction LocalTime -> UTC' Set cn = New ADODB.Connection 'Connexion à la DB' With cn .ConnectionString "Provider SQLOLEDB;Data Source=FR-LAN-RSVIEW-2\SQLEXPRESS;Initial Catalog=FT_log;Uid=Administrateur;Trusted_Connection=yes" 'Chaîne de connexion Sql Server 2005' .Open End With Set rs = New ADODB.Recordset 'Lecture de la DB' With rs .ActiveConnection = cn .Open "SELECT * FROM Actions_OPE WHERE DAY (TimeStmp) = " & Day(DateDeb) & " AND MONTH(TimeStmp)= " & Month(DateDeb) & " AND YEAR(TimeStmp)=" & Year(DateDeb) & "" 'Sélection de la table Actions_OPE' End With
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre question