[INUG-Users] Comparing variables in Event list filter

[SR]

Hi Natasha,

             I suggest you convert both the strings in same format.
like: to_char(TIME1, '%m/%d/%Y %H:%M:%S') > to_char(Time2,'%m/%d/%Y
%H:%M:%S')


Regards,
Fellow Muser.
On Mon, Nov 2, 2009 at 8:07 PM, Bhatt, Natasha <natasha.bhatt at kvh.co.jp>wrote:

>
>
> Hi All,
>
> I am trying to compare 2 time variables in the eventlist filter using the
> condition type as complex. But I am receiving an error as 'Unexpected token
> '(', even though all the paranthesis are set in proper manner.
>
> In the filter, I have put the condition as below:
>
>  to_time(Time1,'%m/%d/%Y %H:%M:%S') > Time2.
>
> Time1 is a character field containing date, therefore it needs to be
> converted.
>
> But when I just put, FirstOccurrence > Time2, then there are no error
> statements..
>
> It seems that filter is not taking any conversion functions.
>
> Is it a limitation of the eventlist filter or am I missing out
> something......
>
> Please let me know.
>
> Thanks and Regards,
> Natasha
>
>
>
>
> ****************************************************************
> "PLEASE NOTE:  This email,  and  any  attachments  hereto,  are
> intended only  for use  by the specified addressee(s)  and  may
> contain legally privileged and/or confidential and/or proprietary
> information of KVH Co., Ltd.  and/or its affiliates  (including
> personal information).  If you are not the intended recipient of
> this email, please immediately notify the sender by email,  and
> please permanently  delete the original,  any print out and any
> copies of the foregoing. "
> ****************************************************************
> _______________________________________________
> Sent by the netcoolusers.org "users" mailing list
> Post: users at netcoolusers.org
> Unsubscribe: users-unsubscribe at netcoolusers.org
> Search: http://netcoolusers.org/Search
>