686322_de-DE

liliconcom

Durchlaufen Sie die Daten

Hallo zusammen,

Ich versuche, einige Daten aus der Datenbank abzurufen, indem ich Datumsangaben durchlaufe. In diesem Beispiel versuche ich, eine Schleife von Juni bis zum gestrigen Datum durchzuführen. Das ist mein Beispielcode. Es funktioniert jedoch nicht. Kann mir jemand erklären, wie man es richtig macht? TIA

 

d = Today() - In Days(1);
dateNow = Format (d, "m/d/y");
startdate = "2023-06-01";

For( i = startdate, i <= dateNow, i++,

try(
dt = Open Database( "DSN=db ;UID=user123;PWD=qwerty;APP=JMP;DATABASE=zxcv;", 
"Select * from table1
where date_time between '" || [i] || " 00:00:00 AM' and '" || [i] || " 11:59:59 PM'",  
"dt1" );

));

Automatisierung und SkripterstellungBetreff: Daten durchlaufen

// The Today() function returns the number of seconds since Midnight, January
// 1st, 1904 which includes the number of seconds since midnight today up 
// until the exact h:m:s the today() function was run.
// I assume you really want the value of the start of today.
dateNow = date mdy(month(Today()),day(today()),year(today())) - In Days( 1 );

startdate = Informat( "2023-06-01", "yyyy-mm-dd" );

// Assuming that you want to increment by 1 day, you need to add a
// days worth of seconds for each loop.  JMP dates are stored in
// the number of seconds since Midnight, January 1, 1904.  
For( i = startdate, i <= dateNow, i = i + In Days( 1 ), 

 // When you reference i or datenow or startdate and you don't want
 // the number of seconds, but rather the date value, you need to
 // use the format() function to convert from the number of seconds
 // to the date display form
 Try(
  dt = Open Database(
   "DSN=db ;UID=user123;PWD=qwerty;APP=JMP;DATABASE=zxcv;",
   "Select * from table1
where date_time between '" || Format( i, "m/d/y" ) || " 00:00:00 AM' and '"
    || Format( i, "m/d/y" ) || " 11:59:59 PM'",
   "dt1"
  );
 )
);