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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Grouping by time intervals
I am attempting to group records by 12 minute intervals. I.E. 12:00pm-12:12pm, 12:13pm-12:25pm, etc. I am currently grouping in 10 minute intervals...although the current method won't exactly work for 12. Can anyone give some advice on this? See the SQL below: SELECT... -
Query to pull data from the past week
Thank you!, The WEEKDAY function appears to be the Informix version of DAYOFWEEK. I fixed it with the following: AND rpt.act_ingate_dtm > (TODAY - WEEKDAY(TODAY)) - INTERVAL(7) DAY TO DAY AND rpt.act_ingate_dtm < TODAY - WEEKDAY(TODAY) -
Query to pull data from the past week
I have a report that is running a query to pull data for the previous 7 days, as shown below in the WHERE clause: AND rpt.act_ingate_dtm > TODAY - INTERVAL(7) DAY TO DAY AND rpt.act_ingate_dtm < TODAY This is always run on Sunday morning currently....but I need to be able to run it any day... -
Clearing Network Credentials
How can I clear automatic login when connecting to a networked computer? I want to be able to choose the specific username but it automatically logs me into just one. I have restarted both computers multiple times to no avail. Thanks!, Mike- kaledev
- Thread
- Replies: 1
- Forum: Microsoft: Windows
-
-
Visio 2003 Hyperlinking Problem
I have noticed in Visio 2003, when I create a transparent shape - and then put a hyperlink on that shape, it does not function when saving the project as a web page. The hyperlink acts like it does not exist, but will work fine within Visio or if it has 100% transparency. I need the effect...- kaledev
- Thread
- Replies: 1
- Forum: Microsoft: Office
