Search results 38

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

ANmAdd_ThenSort_2Columns

Adds values of 2 cells into 2 columns (usually below them). I used these small ...

Jun1

PrCal_Add_Sort

Adds to daily log, two cells, one with date, next with activity that will be ...

2023Dec2

SQL Date from DateTime

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

2023Nov29

BusinessDateDiff

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

2023Oct25

Times_inHours

Calculate the total number of hours between two times and return in format ...

2023Jul20

ANmaDate

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

2023Apr27

ANmaSQL_UpdateDateStatement

Creates "Update Table " SQL statements to be executed inside SQL to modify ...

2022Jul4

ASP Classic Page Cache

Set page to cache at certain time or force cache refresh. Something I found ...

2022May20

DateDiff_En

Calculates the differences of date (against NOW) and return in English ...

2022Mar3

merge2Arrays

Merges two 1-dimension arrays and return an array Both should be 1 dimensional ...

2021Sep21

Highlight row of current month

Highlight row in Excel if it is within current month This is another version ...

2021Sep2

Bootstra/386

A bootstrap v2, v3 or v4 theme to make webpages look like they are from the ...

2021Jan6

ASP to static HTML

Convert Dynamic ASP files into HTML (once daily) to make them faster when ...

2020Dec24

1 2 3