Here are a few examples of how you can use the search feature:

Entering this and that into the search form will return results containing both "this" and "that".

Entering this not that into the search form will return results containing "this" and not "that".

Entering this or that into the search form will return results containing either "this" or "that".

Search results can also be filtered using a variety of criteria. Select one or more filters below to get started.

Assuming days is required, the following 51 results were found.

  1. Windows 7: System Clock is constantly going out of synchttps://joellipman.com/component/content/article/windows-7-system-clock-is-constantly-going-out-of-sync.html?catid=80&Itemid=165

    Double-click on the key on the right-hand side for SpecialPollInterval The default time period is 7 days calculated in seconds. If you wanted to change this to update every day, you would use 86400, or 60 seconds * 60 minutes * 24 hours * 1 day. I...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *

  2. SQL Calendar in Business Intelligence Development Studiohttps://joellipman.com/articles/else/database/t-sql/sql-calendar-in-business-intelligence-development-studio.html

    the web for a way of producing an outlook-style calendar within Business Intelligence Development Studio (BIDS). Weekdays along the top and then dates inside. Additionally we would like this linked to events in a database. I'm calling this project...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB

  3. DataJumble - Shuffling characters in a data valuehttps://joellipman.com/articles/else/database/t-sql/data-shuffling-function.html

    dbo.vwRandom; SELECT @RandDay = (1 - 28) * RandomValue + 28 FROM dbo.vwRandom; -- prevent invalid dates (specifically 31 days in feb) SET @DateVal = CAST(@RandYear AS CHAR(4)) + '-' + STUFF(@RandMonth, 1, 0, REPLICATE('0', 2 - LEN(@RandMonth))) + '-' +...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: *

  4. DataScramble - Randomizing data rowshttps://joellipman.com/articles/else/database/t-sql/datascramble-randomizing-data-rows.html

    dbo.vwRandom; SELECT @RandDay = (1 - 28) * RandomValue + 28 FROM dbo.vwRandom; -- prevent invalid dates (specifically 31 days in feb) SET @DateVal = CAST(@RandYear AS CHAR(4)) + '-' + STUFF(@RandMonth, 1, 0, REPLICATE('0', 2 - LEN(@RandMonth))) + '-' +...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB

  5. MySQL parameters in Excel 2007 PivotTableshttps://joellipman.com/articles/else/database/mysql/mysql-parameters-in-excel-2007-pivottables.html

    Specification PivotTable Report...resources in row (along the side)......staff in columns (along the top)......persondays in values (the number my bosses want - 7h 24m or 26640s is 1 person day)... With date range as parameters...ouch......and it...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB

  6. Slideshow div layer through a windowhttps://joellipman.com/articles/cms/website-development/mootools/slideshow-div-layer-through-a-window.html

    showcase slideshow. Using MooTools it's also proven to be responsive and compatible with smartphones.(Like Flash back in the days of Macromedia Flash :c) and works with apple macs!). The HTML Slide #1 Slide #2 Next Slide The CSS #window_slide{...

    • Type: Article
    • Author: Joel Lipman
    • Category: MooTools Framework
    • Language: *

  7. SITS: Export field code and namehttps://joellipman.com/articles/cms/website-development/xml/sits-export-field-code-and-name.html

    -- yields: A colleague of mine found this ABLANK solution. It took two of us the best part of two days to come up with the SRL syntax... Our XSLT can then do the following: -- for *LookupFailed* both code and name will be blank. -- possibly use...

    • Type: Article
    • Author: Joel Lipman
    • Category: Extensible Markup Language
    • Language: *

  8. Accessing Apimo WebService APIhttps://joellipman.com/component/content/article/accessing-apimo-webservice-api.html?catid=109&Itemid=165

    host. How? Previously, I would have used cURL but for some reason, I couldn't get the configuration right. After several days... I tried the example as per the Apimo documentation and it worked! There were a few adjustments to make which I'm documenting...

    • Type: Article
    • Author: Joel Lipman
    • Category: API Miscellaneous
    • Language: *

  9. MS Excel - Sort pivottable column headings by datehttps://joellipman.com/component/content/article/sort-pivottable-column-headings-by-date.html?catid=110&Itemid=165

    again. Basically I have a pivot table in Microsoft Excel 2010 with the projects down the left (in the first column) and the days of the week along the top. Why? The excel report would hit a bug where it couldn't work out that 10 (Wednesday) happened...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB

  10. Set default parameter dates to start and end of monthhttps://joellipman.com/component/content/article/set-default-parameter-dates-to-start-and-end-of-month.html?catid=75&Itemid=165

    on SQL Server Central.com forums where he subtracts 1 day from the first day of next month to get the last date/number of days in this month.

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: *

  11. MySQL day of week ending on Fridayhttps://joellipman.com/articles/else/database/mysql/mysql-day-of-week-ending-on-friday.html

    next Friday Not sure why this works, thinking about it hurts my head but it worked with my test data (selecting current week days then the following saturday and sunday -- both saturday and sunday returned week ending date as next week). If you were...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
Results 41 - 51 of 51