Search results 106

Card image cap
SQL Date from DateTime

Extract Date from Datetime field in SQL An old method I found in my archive.

Card image cap
HTML2Str

Sppecial version to convert HTML to string. Uses RemoveHTML, then after that ...

Card image cap
Latest records date and count

Find how many items in table, with column DateAdded is the latest DateAdded in ...

Card image cap
Any2Dec

Converts a number of any base to decimal. Hexa to decimal, octa to decimal, ...

Card image cap
Arr_1Dim_2Str

Converts 1-dimension array into text. Meat Join. A way to convert array into ...

Card image cap
Refresh Table from View

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

Card image cap
SubZero

Forces Excel to not convert numbers during moving them across sheets, or ...

Card image cap
ANmaInt

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

Card image cap
DB Functions (By AI)

3 functions to add or update data to DB and Read from DB. These were also ...

Card image cap
Convert_Dash_to_Zero

Convert cells with dashes to zeros. Quick code needed to reset sheet copied ...

Card image cap
Range2Block

Concatenate all rows found in a range starting A1Cell for Columns_To columns ...

Card image cap
UnixDateTimeNumber

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