Search the Community
Showing results for tags 'datetime'.
I have a spreadsheet - daily routine which has two columns: activity and time as shown here | Activity | Time | |----------------------|----------| | Sleep | 6:00 am | | Toilet | 6:15 am | | Get ready for gym | 6:30 am | | Exercise | 7:50 am | | ... more things | 9:00 pm | | ... still more | 10:45 pm | | Sleep | 6:00 am | I wanted to find out, say in C1 which activity is current for me using now() I.e., if it’s 6:45am on my watch, it should show me Exer
I'm trying to display information from my printer queues and I cannot figure how to convert the 'datetime' value returned in the "time submitted" item to a date and time. Here's my test code: test3() Func test3() Local $str, $objWMIService, $AllPrintJobs, $PrintJob While 1 $objWMIService = ObjGet("winmgmts:\\" & @ComputerName & "\root\CIMV2") $AllPrintJobs = $objWMIService.ExecQuery("SELECT * FROM Win32_PrintJob") For $PrintJob In $AllPrintJobs $str = "" $str &= "Name: " & $PrintJob.Name & @CRLF ;
I am attempting to create a script which will poll a SQL database that is part of our internal server monitoring application. The results would then be pushed to the local growl client on my desktop. I am successful at querying the SQL database using the SQL UDF and can send growl notifications fine as well... What I run into is "Syntax error converting datetime from character string." when I try to query the database with the value from a previous query. (My appologies for making this sound confusing) For example, I query the database and return the results into a 2D array. I can displa