Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Fri, 03 May 2024 16:45:40 +0000
Post From: Day of week and time of day alert
| [2018-09-15 14:00:59] |
| Sawtooth - Posts: 3992 |
|
All references to date and time use Serial DateTime Values. Spreadsheet Functions: Serial DateTime Values To reference a specific date, use the DATEVALUE function: =BARDATE=DATEVALUE("09/11/2018") =DATEVALUE("09/11/2018") returns the Date Value of 43354, which is the number of days since 12/31/1899. Notes: 1. This is the only supported syntax in SC: =DATEVALUE("09/11/2018") =DATEVALUE("2018/09/11") is not supported. 2. Excel's Serial Date Time starts on 1/1/1900, not 12/31/1899. Excel: =DATEVALUE("1/1/1900") = 1 Sierra Chart: =DATEVALUE("1/1/1900") = 2 Date Time Of Last Edit: 2018-09-16 19:34:59
|