Talk:Date Data Type
From CometWiki
(New page: Posted by Grant Foraker on September 14, 2009 at 14:43:13: Adding a Date data type to Comet has been discussed at several past Dealer/Developer meetings. So, as a baby step, can we add a ...) |
|||
Line 10: | Line 10: | ||
would prompt a Date Picker because TRANS.DATE was a "D" instead of a "S" field. | would prompt a Date Picker because TRANS.DATE was a "D" instead of a "S" field. | ||
+ | |||
+ | | Posted by Jon Sacks on September 15, 2009 at 06:28:44: | ||
+ | |||
+ | In Reply to: Date data type posted by Grant Foraker on September 14, 2009 at 14:43:13: | ||
+ | |||
+ | All dates should be stored in the system as serial date/time and the mask applied indicates the way it should be displayed. |
Revision as of 10:44, 7 October 2009
Posted by Grant Foraker on September 14, 2009 at 14:43:13:
Adding a Date data type to Comet has been discussed at several past Dealer/Developer meetings. So, as a baby step, can we add a "D" field type to #CFILES.
Right now the majority of dates in my files are either "YYYYMMDD" or "MM/DD/YYYY". The "YYYYMMDD" ones for date sorting (in keys mostly) and the "MM/DD/YYYY" ones for display. The Date Serial Number is another possible option.
So, in the Reporter
SELECTING IF TRANS.DATE EQ "%FromDate%"
would prompt a Date Picker because TRANS.DATE was a "D" instead of a "S" field.
| Posted by Jon Sacks on September 15, 2009 at 06:28:44:
In Reply to: Date data type posted by Grant Foraker on September 14, 2009 at 14:43:13:
All dates should be stored in the system as serial date/time and the mask applied indicates the way it should be displayed.