Comparing Date Fields

[Kasei]

I am sure this has been covered, however I am working in FileMaker 5.5 and I sometimes run into trouble using FileMaker 8 calculations.

I have two date fields "Target Launch Date" and "Launch Date". The Target Launch Date must be less than the Launch Date. If the Launch Date is greater than the Target Launch Date I need for the field or Text to turn red.

Any suggestions?

Thanks for your help.

[Vaughan]

There are no text colour changing functions in FMP 6 and earlier.

The hack was to create a calc field that displayed the text when the necessary condition was true. Put this field on the layout and format it as red text, and don't allow entry.

[Kasei]

Thanks... This is the problem I have been running into working in FileMaker 5.5

Edited July 10, 2007 by Guest

[Lee Smith]

It wouldn't matter which of the version you are using, the procedure you would need to use is the same as what vaughan described. Version 7 finally provided a native way to do this, but in prior versions you would need to do a [color:red]workaround. I prefer to refer to these types of things as workarounds, and not hacks, as you really are working around a limitation of the application, not changing the code.

This topic has come up a lot in the past. Do a search for [color:blue]+Changing +Background +Color, or [color:blue]+Flag +Field, and you should find a lot of help.

Just be sure that they are talking about a version older than 7, or that the attachment uses the extension of .fp5

HTH

Lee

[Kasei]

Thanks Lee,

Working with FileMaker 5.5 requires a lot of workarounds and thanks to you guys I have been able to remain sane during this project. I'll have to go through FM and see if I can find what I am looking for.

Cheers,

Kasei

[Lee Smith]

Here is a file I submitted that may help you.

Link

or maybe this one Link

Like I said before, there are a lot of other threads on this topic.

Lee

[Kasei]

Lee,

Thanks for the help. It turns out I was making the calculation much harder than it really needed to be.

Thanks again for the help.

Cheers,

Kasei