Similar codes
SQL Date from DateTime
Extract Date from Datetime field in SQL An old method I found in my archive.
Nov29
VBInstr (or Instr parameters)
The great function InStr I use a lot has a small confusing part. Which string ...
2019Jan9
DB_AllRows
Returns all rows found from an SQL Query as string Separated by row and column ...
2018Apr23
Records Affected by Execute command
Records affected by sql Execute command https://docs.microsoft. ...
2018Sep1
Random Number in SQL
Generate Random number inside SQL using timestamp (GetDate function) One of ...
Jan30
InStr and InStrRev
How to use InStr and InStrRev VB functions It is silly, I know, but I keep ...
2021Dec6
CutString8
Cuts a string from certain character to certain character with option of either ...
2021May29
Recently by developer
CountColumnCells_2Criteria
Counts how many cells matching 2 criterias.
Just like
May1
Files_FoundHours
Listing the file from a folder that was created during last few hours. Can ...
Apr30
Random Codes
UnixDateTimeNumber
Calculates Unix date/time number of a given date/time. Needed it to pass ...
2023Jan6
AddDatabar_ConditionalFormatting
Adds databars conditional formatting to range of cells. Passing column, start ...
2022Aug22
