fompwath Posted February 27, 2005 Share Posted February 27, 2005 I have a value list that I would like to store dates in order. This value list is generated from a field, but unfortunately that field is NOT defined as a "date" field, but rather text (ignore why I did this). Consequently, "2/14/05" comes before "2/7/05". GRRRRR! Any thoughts? Link to comment Share on other sites More sharing options...
Maarten Witberg Posted February 27, 2005 Share Posted February 27, 2005 Perhaps make another field, calculation, probably unstored, cRealDate=texttodate(TextDateField) and make the value list of that one.... kjoe Link to comment Share on other sites More sharing options...
fompwath Posted February 28, 2005 Author Share Posted February 28, 2005 Worked like a charm. Thanks! Link to comment Share on other sites More sharing options...
By Soliant Consulting,
By Soliant Consulting,
By Soliant Consulting,
Recommended Posts
Archived
This topic is now archived and is closed to further replies.