FMP Custom Date Format Problem

Thread View: comp.sys.mac.databases

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by Vincent Heuring Sun, 10 Jan 1993 23:41

#608

Author: Vincent Heuring
Date: Sun, 10 Jan 1993 23:41

22 lines
1324 bytes

I am trying to create a date field with a custom date format of the
kind mm/yy, as in 12/92. I go to the date format in the format menu,
and create a custom date that looks like: month /  year empty empty empty.
But when I try to actually enter a date in that form, I get a dialog box
that says

	"The date in this field must have a valid date in the range of
	years 1 to 3000, and should look like "12/31/92."

Is this a FMP message, or a system message? The system date format
does not allow a format of the form mm/yy. The day must always be
present. Is this a FMP bug, or am I overlooking something?

I've tried calling Claris Tech Support, but their line is *always* busy,
at least when I've called.

-- 
---
 Vincent Heuring   Dep't of Electrical & Computer Engineering
 University of Colorado at Boulder      Boulder CO 80309-0425
 heuring@cs.Colorado.EDU   o) 303-492-8751    h) 303-449-8868

Re: FMP Custom Date Format Problem

#614

Author: Charles Albrecht
Date: Mon, 11 Jan 1993 21:40

30 lines
1964 bytes

In article <1993Jan10.234156.10100@colorado.edu> heuring@riker.cs.colorado.edu (Vincent Heuring) writes:
>
>I am trying to create a date field with a custom date format of the
>kind mm/yy, as in 12/92. I go to the date format in the format menu,
>and create a custom date that looks like: month /  year empty empty empty.
>But when I try to actually enter a date in that form, I get a dialog box
>that says
>
>	"The date in this field must have a valid date in the range of
>	years 1 to 3000, and should look like "12/31/92."
>
>Is this a FMP message, or a system message? The system date format
>does not allow a format of the form mm/yy. The day must always be
>present. Is this a FMP bug, or am I overlooking something?
>

This is a FM Pro message, but I believe it checks your system's international
settings to find the form that it expects.  Changing the Date format
as you describe will only change the way the data is displayed.  FM Pro
doesn't have input filters (unlike 4D).  The only thing FM is smart enough
to do is to add the current year if you leave it off.  So in your example,
it's assuming that you mean 12/92/93, which doesn't make any sense to it.

One way to simulate this is to use a Text field and a Date-Calculation field.
Your calculation would parse the text expression and add "one" for the day
of the month.  It would use the display option that you designed above.
In my opinion, this is a bit too much work.

-Charles
 charlesa@ncar.ucar.edu

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads