How to validate time format from a text field?
in [General]
|
Prev: "Automatic Configuration of Access has failed" 2007 was working fi
Next: Coding Convention for using Binary FlagWords?
From: wdsnews on 15 May 2010 13:06 The goal is to normalize data before converting text fields to datetime fields. There are start times and end times stored in text fields of a table. The problem is that any criteria used in a query causes errors when any function causes text to be converted to a datetime type, and the text field does not contain a valid date or time. I'm familiar with some of the validation functions such as isNull(), but I can't find anything like isTime(). How can I test existing data for valid time format?
From: Douglas J. Steele on 15 May 2010 13:17 IsDate works on time as well. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "wdsnews" <wdsnews.0640(a)oregoncity.com> wrote in message news:ujZDvDF9KHA.3176(a)TK2MSFTNGP05.phx.gbl... > The goal is to normalize data before converting text fields to datetime > fields. > > There are start times and end times stored in text fields of a table. The > problem is that any criteria used in a query causes errors when any > function causes text to be converted to a datetime type, and the text > field does not contain a valid date or time. > > I'm familiar with some of the validation functions such as isNull(), but I > can't find anything like isTime(). How can I test existing data for valid > time format? > > >
From: WDSnews on 15 May 2010 13:44
thank you "Douglas J. Steele" <NOSPAM_djsteele(a)NOSPAM_gmail.com> wrote in message news:eR4sRKF9KHA.4600(a)TK2MSFTNGP02.phx.gbl... > IsDate works on time as well. > > -- > Doug Steele, Microsoft Access MVP > http://I.Am/DougSteele > (no private e-mails, please) > > > "wdsnews" <wdsnews.0640(a)oregoncity.com> wrote in message > news:ujZDvDF9KHA.3176(a)TK2MSFTNGP05.phx.gbl... >> The goal is to normalize data before converting text fields to datetime >> fields. >> >> There are start times and end times stored in text fields of a table. >> The problem is that any criteria used in a query causes errors when any >> function causes text to be converted to a datetime type, and the text >> field does not contain a valid date or time. >> >> I'm familiar with some of the validation functions such as isNull(), but >> I can't find anything like isTime(). How can I test existing data for >> valid time format? >> >> >> > > |