Home : Date Serial Number
Q14627 - INFO: Date Serial Number

WIMS stores Text Variables with Text Var Format set to Date Entry, Time Entry, and Date/Time Entry as a sequential serial number defined as the number of days from Dec 31st, 1899.  The decimal portion represents the time of that day (i.e. .5 means noon).  Examples Entries are in mm/dd/yyyy format.

Examples:
Entry Date Serial Number
01/01/2021 44197
01/02/2021 44198
01/02/2021 12:00 PM 44198.5
01/02/2021 7:55 AM 44198.33

See Also:  DFORMAT, VAL, Using Text Variables in calculations and graphs, Text Format Tab - Edit/View Variables, FRC

 

Related Articles
No Related Articles Available.

Article Attachments
No Attachments Available.

Related External Links
No Related Links Available.
Help us improve this article...
What did you think of this article?

poor 
1
2
3
4
5
6
7
8
9
10

 excellent
Tell us why you rated the content this way. (optional)
 
Approved Comments...
No user comments available for this article.
Created on 1/27/2021 4:20 PM.
Last Modified on 7/21/2021 9:26 AM.
Last Modified by Scott Dorner.
Article has been viewed 1308 times.
Rated 1 out of 10 based on 1 vote.
Print Article
Email Article