date input mask

[[email protected]]

hi...

I had make an old software in DBASE III .. and we can set in an input mask like xx/xx/xxxx (for the date..) It's easy. You just type 10102001 and the you received back 10/10/2002.

How can i use that function in Filemaker? Maybe with an Add?

Thanks

[petert]

quote:

---

Originally posted by serge:

hi...

I had make an old software in DBASE III .. and we can set in an input mask like xx/xx/xxxx (for the date..) It's easy. You just type 10102001 and the you received back 10/10/2002.

How can i use that function in Filemaker? Maybe with an Add?

Thanks

---

[petert]

quote:

---

Originally posted by serge:

hi...

I had make an old software in DBASE III .. and we can set in an input mask like xx/xx/xxxx (for the date..) It's easy. You just type 10102001 and the you received back 10/10/2002.

How can i use that function in Filemaker? Maybe with an Add?

Thanks

---

*********

This is pretty primitive but it does work. You could try using 3 fields:

Field 1: dateInput [text]

Field 2: dateConvert [calculation, result is text,

Left(dateInput,2) & "/" & Middle(dateInput, 3, 2) & "/" & Right(dateInput, 4)

Field 3: dateResult [calculation, result is date,

TextToDate(dateConvert)]

This gives you 1 entry step and two auto steps to the desired result.

Input:______18121969

1st Step:____18/12/1969

Result:_____18/12/1969

There is probably a more elegant solution, but sometimes you need to go for whatever you can think of first.

Have a Great day!

pete

:cool

[ March 13, 2002, 02:41 AM: Message edited by: petert ]

[SteveB]

Why not just format the date field (I'm assuming the field we are discussing is of type 'date') which will cause FM to display the date however you choose?