Converting fields

[stigh]

Hi again,

Need so tolve following problems:

In my base, I have date & time fields.

For the ease of entering, I would like just to type in date as numbers, and the same with time (without using separators).

Example 24 hour format: for 13:30, just type 1330.

Example for date: for 15.10.00, just type 151000.

But AFTER I press tab (or enter), FM must convert these fields to appropiate format, i.e. time xx:xx and time xx.xx.xx.

How do I do that???

Thx,

/Stigh

[Kurt Knippel]

quote:

---

Originally posted by stigh:

Hi again,

Need so tolve following problems:

In my base, I have date & time fields.

For the ease of entering, I would like just to type in date as numbers, and the same with time (without using separators).

Example 24 hour format: for 13:30, just type 1330.

Example for date: for 15.10.00, just type 151000.

But AFTER I press tab (or enter), FM must convert these fields to appropiate format, i.e. time xx:xx and time xx.xx.xx.

How do I do that??

---

Formatted Text fields would be the only way, short of scripting.

You would need to create 2 fields, one would be a normal Text entry field. The other would be a calculation. Lay this on top of your text field, and set the calc for for not allow entry.

------------------

=-=-=-=-=-=-=-=-=-=-=-=-=

Kurt Knippel

Consultant

Database Resources

mailto:[email protected]

http://www.database-resources.com

=-=-=-=-=-=-=-=-=-=-=-=-=

[LiveOak]

It's a good idea, but what date does 11111 convert to? -bd

[FW]

Sorry for dredging up an old topic for my first post, but thought that this info might be useful for anybody concerned.

For date fields you can simply type in the month and date with a space between.... 12 17 will get you 12/17/2000... the date will default to the present year. For other year dates you can simply add the year... 12 17 98 etc...

No such luck with time fields though.