Search results 60

Sorted from new to old.

Quarter1stLastDate_FromQuarterText

Returns the date of 1st day or last day in a Quarter Mar 31st, Jun 30th, Sep ...

Jul26

QuarterNumber_FromDate

Returns the number of quarter from a date

Jul26

Q_NoOfdays

Calculates number of days for certain quarter, starting from given quarter with ...

Jun9

NumberNumberNumber

Finds 3 numbers in a string by ignoring characters between them. ' example ...

Mar2

SQL Cross Apply String_Split with XML Path

SQL select statement to convert list of IDs found in column (from more than row ...

Jan20

Grandchildren files and count

Returns list of files in 2 level folders Will not find files as children of ...

Jan11

Macro keyboard shortcuts

Assign certain keyboard shortcut to certain macro, or clear that shortcut. ...

2023Dec13

Latest records date and count

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

2023Nov2

BusinessDateDiff

Number of Business days between two dates. Note that it doesn't take Christmas, ...

2023Oct25

ANmaHTMLContent

Reads certain part in HTML output of a page. Will search for list of strings ...

2023Jul1

ANmaDate

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

2023Apr27

WordPress - Excel functions (AI)

3 functions to download posts, adds new post and to upload and set featured ...

2023Apr22

Arabic in MySQL

Here is how to read Arabic text from MySQL db from Classic ASP I tried a lot ...

2023Apr12

ScanFolder

Scans folder and its all subfolders (2 levels only) for files then put file ...

2023Apr7

EmailSend_Outlook

Send email using Outlook object with attachments With AI-generated post image. ...

2023Apr5

Excel recovered files

Location of Excel recovery workbooks in your system when Excel crashes, it ...

2023Mar31

1 2 3 4