Extract Date from Datetime field in SQL An old method I found in my archive.
Nov29
The great function InStr I use a lot has a small confusing part. Which string ...
2019Jan9
Returns all rows found from an SQL Query as string Separated by row and column ...
2018Apr23
Records affected by sql Execute command https://docs.microsoft. ...
2018Sep1
Generate Random number inside SQL using timestamp (GetDate function) One of ...
Jan30
How to use InStr and InStrRev VB functions It is silly, I know, but I keep ...
2021Dec6
Cuts a string from certain character to certain character with option of either ...
2021May29
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
Show or hide item (or items) in PivotTable for a certain field. Passing ...
Jan23
Calculates Unix date/time number of a given date/time. Needed it to pass ...
2023Jan6
Removes last row in a table starting certain cell. Creating and using this ...
2022Aug16