Create summary list If you have SQL table named Table_Name, with DateAdded ...
2018Sep22
Counts the number of business days Add or subtract a number of business days ...
Oct11
Gets list of years and total of posts per year from a table, by using date ...
2018Jul29
3 functions to add or update data to DB and Read from DB. These were also ...
2023Apr23
Creates "Update Table " SQL statements to be executed inside SQL to modify ...
2022Jul4
Create summary list If you have SQL table named Messages, with DateStamp ...
2018Dec15
Extract Date from Datetime field in SQL An old method I found in my archive.
Nov29
Returns date in human format. Which is as follows... Just day name (and time) ...
2023Apr27
Counts how many cells matching 2 criterias.
Just like
May1
Listing the file from a folder that was created during last few hours. Can ...
Apr30
Checks if an item was found in list of items and return 1 if yes, 0 if not ...
Dec19
Reads certain part in HTML output of a page. Will search for list of strings ...
Jul1
Disables or Enables certain Excel built-in shortcut. Code has example on how ...
2018Aug16
Logs out Linkedin by running two commands One will open new window to logout ...
2018Apr23