TIME and Date: Set and Convert. Calendar Functions

The explicit result of TIME is always the number of seconds elapsed since midnight
- sec_since_midnite = TIME( options ) ! e.g. 86399.000 at 23:59:59
TO: elements left of keyword "TO" are converted to the optional variables right of "TO", like
- TIME(YYYYMMDD=19991231, TO, Excel=x) ! x is set to 36525
If TO is the first keyword, the current date and time become the default
- TIME(TO, YYYYMMDD=text) ! e.g. "20080728123920.567"
To measure the time passed between calls:
- tstart = TIME()
- seconds_elapsed = TIME() - tstart
To
display_elapsed_cpu_times
on the main window status bar:
- either click Menu - Go - CPU toggle
- or press Alt+M to toggle CPU time display On/Off
- or set the display state by the statement
  - TIME( CPU = n ) ! with n = 1 (On) or n = 0 (Off)
  With "CPU toggle On" the status bar display is updated:
  - in debug mode (step or trace) following every statement.
  - between DLG/Messagebox calls.
  - while executing long running EDIT(... DO...) statements
  measure_cpu_time
  elapsed while a script is running
- - TIME( CPU = string ) ! display string and elapsed time whenever called

options	type	description	range
Year	NUM	year, e.g. 2008	---
MOnth	NUM	month TIME(TO, MOnth=m, Day=d) ! get current numeric month and day Tip: Convert month number mm to its name xyz = CHAR(mm, 12, "JanFebMarAprMayJunJulAugSepOctNovDec") ! xyz is set to Mar	1...12
Day	NUM	day of the month	1...31
Hour	NUM	hour	0...23
MInute	NUM	minute	0...59
Sec	NUM	seconds	0...59
MSec	NUM	milliseconds	0...999
WeekDay	NUM	output only: numeric day of the week, Monday == 1	1...7
	TXT	output only: string day of the week "Monday", "Tuesday", ...	Mon...Sun
Excel	NUM	day number after Dec 31, 1899 (Excel day 1) TIME(Day=6, MOnth=7, Year=2009, TO, Excel=x) ! x set to 40000 WRITE(Text=text, Format="UWWW CCYY/MM/DD") 40000 ! text set to Mon 2009/07/06	---
Gregorian	NUM	Gregorian day number TIME(Day=15, MOnth=10, Year=1582, TO, Gregorian=daynr, WeekDay=i, Excel=x) ! daynr=2299161; i=5; x=-115858; The Gregorian calendar is the de facto international standard, decreed by Gregory XIII on Fri, 15 Oct 1582.	---
YYYYMMDD	NUM	8 pre-decimal digits YYYYMMDD plus fractionalday
	TXT	≤18 characters date and time YYYYMMDDhhmmss.msec TIME(YYYYMMDD=19991231.375+7.5/60/24, TO, YYYYMMDD=text, YYYYMMDD=y) ! results in text = "19991231090730.000" ! and y = 19991231.38	YYYY=0....9999, MM=1...12, DD=1...31, hh=0...23, mm=0...59, ss=0...59, msec=0...999