Aviation date time input e.g. 151400KAPR11

[wish2bflying]

I'm getting "The value you entered isn't valid for this field" when trying to set up a date input field on a form that I want people to be able to just enter the numbers as they would normally write them, e.g. 151400KAPR11 (the "K" is the timezone), and have the database store it normally and display it as it's been entered.

I've tried using the Format

ddhhnn\Kmmmyy

by itself, and the Input Mask

!000000\K>LLL00;0;_

by itself, and also both together, but I can't seem to make this work.

Using the Input Mask by itself brings up the spaces and the "K" properly, but it just won't accept the values. If I take out the input mask and just use the Format string, I have to enter the data in a "standard" format, like "15 apr 11 2:24pm", and then it will display it as I want it to (unfortunately without the month in all caps, but that's a problem for another day).

Ideas?

Feel free to simply point me to a website that might deal with this problem. I've done a fair bit of Googling but haven't found anything that has helped.

 

[alansidman]

Unless you are going to use the "Date/Time" in calculations, then why not store it as a text value. Are you going to need to do calculations?

Alan

 

[wish2bflying]

Hi, sorry for the delay in replying.

Yes, we will be reporting on the date figures and need to manipulate them. I suppose there could be an OnExit function that would take the text and turn it into a date/time that would be stored in the table, but the field on the form would display it in the format we want.

I was hoping there would be an "easier" way of doing it by input mask and format, but perhaps my understanding is too limited.

Funny how it says "New Member" under my username, then shows my Join Date as almost 7 years ago. I know it's only looking at the number of posts, but I still think it's funny ...