In message <Marcel-1.53-0406114214-b49tRkF@...> you wrote:

> On Mon 05 Apr, B21306@... wrote:
> >
> > Hello All,
> >
> > In one problem I can not found a solution.
> >
> > The problem is....
> > In a Query window createt with SAM I can found a Date Value eg.
> > 05/04/2004 that is all right.
> >
> > But !!! when a another Query field is a Date Value with !! Subtype
> > time/date interval for search age eg. 6d or 2y this work not :-(.
> >
> > I mean ?? in the second Query field must SAM use @datesi but it use
> > @datesn so only Date Value without subtype works or ?
> >
> > Is there a Bypass available for a age search ?
> > I can not become a time/date interval value in a string value.(error)
>
> Nah,... wenig zu tun hier nicht?
> Hallo Hans-Juergen,
>
> Habe mal gewartet ob einer etwas antworten wollte, scheint nicht so zu
> sein :-(
>
> Aber auf English:
>
> I've looked into some of my applications and have found the data types
> of all fields in the queries to be a special 'system(xx)' type.
Hmmm...
Yes I have see this but I think this is not the main problem.
SBase SAM use in the Query the data typ from File without subtype or ?

Ok I can use in the File datatype string but in the card I must ??? use
with my Expression a proc with /:i and this bring the Error when I like
become the age ine use.
I found no way give proc a return value for age us string.
So I must not need in the Card Expression field proc age/:i .
^^^
--------------------------
def proc age_show

if r_froster_card.g_date <1
r_froster_card.g_age = 0

else

r_froster_card.g_age = (@date-r_froster_card.g_date)
endif

if @date < r_froster_card.g_date
r_froster_card.g_age = 0
endif

return r_froster_card.g_age

enddef

------------------------------------------------
I will look for a another solution again.
Thank You very much for Your help Wim !!

A Happy Easter for All say

Hans-Juergen Barthelmehs



>
> What you want to do is hard as the field is specially shown through the
> @date.. command. I do not think the way you want to search for it is the
> way the data is stored in the database...
>
> Sorry...
>
> >
> > Can plaese everyone give me a Hint.
> >
> > Sorry for my bad english.
> >
> > Thanks for a answer and Regards say
> >
> > Hans-Juergen Barthelmehs
> >
>
> Gruß
> Wim