Reply to thread

Message

<blockquote data-quote="eNerGiZer1010" data-source="post: 740" data-attributes="member: 413">G'Day Folks,I have a script that I want to use with SQL Server. What I want the script to do is run a query in in sql for the current date time as star date time and current date time -24 hours for end date time. The script is supposed to run daily reports taking bd for the past 24 hours. My problem is that i'm not sure what to write in the script to set the start date time as (windows current time) and the end date time as (windows current time - 24 hours).Here is the script:if StartDateTime = &quot;&quot; then&nbsp; &nbsp; Prompt1 = &quot;Enter the start date for the report.&quot; &amp; vbcrlf &amp; &quot;Format: yyyy-mm-dd HH:mm:ss&quot;&nbsp; &nbsp; StartDateTime = InputBox(Prompt1,&quot;Report Start Date&quot; , DefaultStartDateTime)&nbsp; &nbsp; if len(startDateTime) = 0 then&nbsp; &nbsp; &nbsp; &nbsp; 'User click on Cancel&nbsp; &nbsp; &nbsp; &nbsp; Wscript.Echo &quot;Report Generation has been cancelled.&quot;&nbsp; &nbsp; &nbsp; &nbsp; Wscript.Quit&nbsp; &nbsp; End Ifend ifif EndDateTime = &quot;&quot; then&nbsp; &nbsp; Prompt2 = &quot;Enter the End date for the report.&quot; &amp; vbcrlf &amp; &quot;Format: yyyy-mm-dd HH:mm:ss&quot;&nbsp; &nbsp; EndDateTime = InputBox(Prompt2,&quot;Report End Date&quot; , DefaultEndDateTime)&nbsp; &nbsp; if len(EndDateTime) = 0 then&nbsp; &nbsp; &nbsp; &nbsp; 'User click on Cancel&nbsp; &nbsp; &nbsp; &nbsp; Wscript.Echo &quot;Report Generation has been cancelled.&quot;&nbsp; &nbsp; &nbsp; &nbsp; Wscript.Quit&nbsp; &nbsp; End Ifend ifFrom my understanding I will need to write a function so that start date time = windows current date time and that end date time = windows current date time - 24 hours. P.S. Is the format of the date time in windows the same as the format of the script because that could be a problem?Thanks for all the help.Your's truly.</blockquote>

[QUOTE="eNerGiZer1010, post: 740, member: 413"] G'Day Folks, I have a script that I want to use with SQL Server. What I want the script to do is run a query in in sql for the current date time as star date time and current date time -24 hours for end date time. The script is supposed to run daily reports taking bd for the past 24 hours. My problem is that i'm not sure what to write in the script to set the start date time as (windows current time) and the end date time as (windows current time - 24 hours). Here is the script: if StartDateTime = "" then Prompt1 = "Enter the start date for the report." & vbcrlf & "Format: yyyy-mm-dd HH:mm:ss" StartDateTime = InputBox(Prompt1,"Report Start Date" , DefaultStartDateTime) if len(startDateTime) = 0 then 'User click on Cancel Wscript.Echo "Report Generation has been cancelled." Wscript.Quit End If end if if EndDateTime = "" then Prompt2 = "Enter the End date for the report." & vbcrlf & "Format: yyyy-mm-dd HH:mm:ss" EndDateTime = InputBox(Prompt2,"Report End Date" , DefaultEndDateTime) if len(EndDateTime) = 0 then 'User click on Cancel Wscript.Echo "Report Generation has been cancelled." Wscript.Quit End If end if From my understanding I will need to write a function so that start date time = windows current date time and that end date time = windows current date time - 24 hours. P.S. Is the format of the date time in windows the same as the format of the script because that could be a problem? Thanks for all the help. Your's truly. [/QUOTE]

Verification