Search results 72

Sorted from new to old.

BusinessDateAdd

Counts the number of business days Add or subtract a number of business days ...

2023Oct11

Times_inHours

Calculate the total number of hours between two times and return in format ...

2023Jul20

Refresh Table from View

Convert SQL View into table for speed reading. Using views a lot, I needed a ...

2023Jul19

ANmaInt

Cuts the integer part of a number. Like INT, FIX, or CINT I know we already ...

2023May2

ANmaDate

Returns date in human format. Which is as follows... Just day name (and time) ...

2023Apr27

UnixDateTimeNumber

Calculates Unix date/time number of a given date/time. Needed it to pass ...

2023Jan6

RunOnTime

Runs a certain macro on certain time. This is not a scheduler, but just simple ...

2022Sep29

SQL Related posts

Steps to create related posts query in SQL. Index, catalog, matching posts for ...

2022Jul6

ASP Classic Page Cache

Set page to cache at certain time or force cache refresh. Something I found ...

2022May20

Too large procedures

No longer than 2.9k lines in a sub Oops. Baaaaad coding habits This also ...

2022Jan29

Highlight row of current month

Highlight row in Excel if it is within current month This is another version ...

2021Sep2

Excel crashes when File > Print

During generating Print Preview, Excel crashes. Applies to some files, not all, ...

2021Mar6

Bootstra/386

A bootstrap v2, v3 or v4 theme to make webpages look like they are from the ...

2021Jan6

Nautical/Flight Functions

Functions perform various calculations useful for planning trips. MPH2Kt: ...

2020Oct13

Windows 7 Photo Viewer

Reg file to show Windows Photo Viewer as option to open images with. ...

2020Sep19

Random GUID

Generate a random GUID using oracle db workbench Also add timestamp to ensure ...

2019Dec22

1 2 3 4 5