' 2019:02:05 17:50:30
tm$ = "1978:09:30 15:00:00"
'tm$ = "1970:01:02 00:00:00"
'DIM tm_sec AS _INTEGER64
'DIM tm_min AS _INTEGER64
'DIM tm_hour AS _INTEGER64
'DIM tm_day AS _INTEGER64
'DIM tm_month AS _INTEGER64
'DIM tm_yday AS _INTEGER64
tm_year
= VAL(MID$(tm$
, 1, 4)) - 1900
tm_yday
= INT(275 * tm_month
/ 9) - (INT((tm_month
+ 9) / 12) * (1 + INT((tm_year
- 4 * INT(tm_year
/ 4) + 2) / 3))) + tm_day
- 30
tm_epoch&&
= tm_sec
+ tm_min
* 60 + tm_hour
* 3600 + (tm_yday
- 1) * 86400 + (tm_year
- 70) * 31536000 + INT((tm_year
- 69) / 4) * 86400 - INT((tm_year
- 1) / 100) * 86400 + INT((tm_year
+ 299) / 400) * 86400
PRINT tm_yday
' check: https://www.esrl.noaa.gov/gmd/grad/neubrew/Calendar.jsp?view=DOY&year=2021&col=4 PRINT tm_epoch&&
' check: https://www.epochconverter.com/ 'PRINT
'PRINT (tm_year - 70) * 31536000&& ' this is the bastard
'PRINT INT((tm_year - 69) / 4) * 86400
'PRINT INT((tm_year - 1) / 100)
'PRINT INT((tm_year + 299) / 400) * 86400