dbTalk Databases Forums  

Find dates <//

comp.databases.filemaker comp.databases.filemaker


Discuss Find dates <// in the comp.databases.filemaker forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Christoph Kaufmann
 
Posts: n/a

Default Find dates <// - 01-14-2011 , 08:25 AM






FMP 10v03 Adv on Mac: I tell a buttom to do a simple find with <//
(anything smaller than today's date) in a date field, and it works.

Open the solution on Win XP, same FMP version, and it doesn't accept the
<// in the date field.

Is that a bug, a feature or something I missed?

Now I wrote a script that goes to search mode and puts a calculated
result in the field.
--
http://clk.ch

Reply With Quote
  #2  
Old   
Howard Schlossberg
 
Posts: n/a

Default Re: Find dates <// - 01-14-2011 , 01:25 PM






On 1/14/2011 6:25 AM, Christoph Kaufmann wrote:
Quote:
FMP 10v03 Adv on Mac: I tell a buttom to do a simple find with<//
(anything smaller than today's date) in a date field, and it works.

Open the solution on Win XP, same FMP version, and it doesn't accept the
// in the date field.

Is that a bug, a feature or something I missed?

Now I wrote a script that goes to search mode and puts a calculated
result in the field.

Works for me on XP with FM10. Are you sure you were in Find mode when
you did it? What error message do you get?

Reply With Quote
  #3  
Old   
Your Name
 
Posts: n/a

Default Re: Find dates <// - 01-14-2011 , 05:26 PM



In article <igq7v0$1e9$1 (AT) news (DOT) motzarella.org>, Howard Schlossberg
<howard (AT) nospam (DOT) fmprosolutions.com> wrote:

Quote:
On 1/14/2011 6:25 AM, Christoph Kaufmann wrote:
FMP 10v03 Adv on Mac: I tell a buttom to do a simple find with<//
(anything smaller than today's date) in a date field, and it works.

Open the solution on Win XP, same FMP version, and it doesn't accept the
// in the date field.

Is that a bug, a feature or something I missed?

Now I wrote a script that goes to search mode and puts a calculated
result in the field.

Works for me on XP with FM10. Are you sure you were in Find mode when
you did it? What error message do you get?
In the older versions of FileMaker you couldn't use the symbols in date /
time Fields via the Set Field command for Find Scripts.

For example,
Set Field [MyField; StartDate & "..." & EndDate]
would never work. Instead you had to use the Insert Calculated Result command
i.e.
Insert Calculated Result [MyField; StartDate & "..." & EndDate]

Even then FileMaker wouldn't recognise Dates / Times properly, so you have
to also use the DateToText function.
i.e.
Insert Calculated Result [MyField;
DateToText(StartDate) & "..." & DateToText(EndDate)]

Could be the same bug.

Helpful Harry )

Reply With Quote
  #4  
Old   
Michael Myett
 
Posts: n/a

Default Re: Find dates <// - 01-14-2011 , 06:44 PM



On Fri, 14 Jan 2011 15:25:53 +0100, clk (AT) tele2 (DOT) ch (Christoph Kaufmann)
wrote:

Quote:
FMP 10v03 Adv on Mac: I tell a buttom to do a simple find with <//
(anything smaller than today's date) in a date field, and it works.

Open the solution on Win XP, same FMP version, and it doesn't accept the
// in the date field.

Is that a bug, a feature or something I missed?

Now I wrote a script that goes to search mode and puts a calculated
result in the field.
I've tried it on FMP Adv 10.0v3 and it works fine. I am running it on
a Win 7 machine not XP but I doubt that makes a difference.

Reply With Quote
  #5  
Old   
Christoph Kaufmann
 
Posts: n/a

Default Re: Find dates <// - 01-15-2011 , 02:49 AM



Howard Schlossberg wrote:

["<//" in a date field on XP, Poblem solved now]
Quote:
Are you sure you were in Find mode when
you did it? What error message do you get?
Just the "no records found" thing you get when you do a search; and the
<// was still in the field; meaning it didn't replace the // by today's
date.

Quote:
Works for me on XP with FM10.
Got it working here just by re-entering the <// in the find step. Brrr,
should have tried that first. May there was a blank character in there
and Filemaker didn't mind that on Mac.
--
http://clk.ch

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.