Hi, I'm getting the wrong result from the date conditions in my form.

occasionally my code merges the wrong images and I think I need a better code to reflect the right dates and attached the right terms.

I'm checking the dates and according the dates the right Term should be merged to the documents, but it's failing now. I have many several dates that requires different Terms and Conditions.

I have created 6 condition one for each date, for example this one should merge the term effective 01/08/2017 +

Condition Name: "Eng_Effective_Aug_1_2017_and_after"
for this record date is = 28/06/2017

=((@(93,7,10)>'2016') or ((@(93,7,10)='2017') and (@(93,4,5)>'07')) or (((@(93,7,10)='2017') and ((@(93,4,5)='08') and ((@(93,1,2)>'01') or (@(93,1,2)='01'))))))

This condition should be False but it's showing True!

Is there any better way or a function to compare different dates via PressTalk or in a condition?

Thank you for your help.

You can't compare two string @(93,7,10), '2016' and expect them to know that they are actually numbers. This is PressTalk, not Javascript .

Try it like this:
=(strtoint((@(93,7,10))>2016) or (strtoint((@(93,7,10))=2017) and (strtoint(@(93,4,5))>7)) or (((@(93,7,10)='2017') and ((@(93,4,5)='08') and ((strtoint(@(93,1,2))>1) or (@(93,1,2)='01'))))))

The "=" will do it but not "<" nor ">"
On another note, there will be a comparison if you use "<" or ">" with strings but not a numerical one.

I still have Type/Syntax() "((@(93,7,10)>'2016')"

I tried to add or remove some brackets () but it's not helping

by bad...try this:
=((strtoint(@(93,7,10))>2016) or ((@(93,7,10)='2017') and (strtoint(@(93,4,5))>7)) or (((@(93,7,10)='2017') and ((@(93,4,5)='08') and ((strtoint(@(93,1,2))>1) or (@(93,1,2)='01'))))))

Jean, there's no syntax error but the result is the same as what I initially got!

Aug_1_2017_and_after is my condition

Date is reading 28/06/2017 , I want to apply any date after August 1st 2017 and data is before August so it should be false, but it's showing true! any thoughts?

Right at first, you check if it is bigger than 2016...it is..os it is true.

I"m confused, so I split to see the result

=((strtoint(@(93,7,10))>2016) YES it's 2017
or ((@(93,7,10)='2017')

and (strtoint(@(93,4,5)) > 7)) NO it's 06
or (((@(93,7,10)='2017') YES

and ((@(93,4,5)='08') and ((strtoint(@(93,1,2)) > 1) NO

or (@(93,1,2)='01')))))) NO

result should be false!

28/06/2017 is not bigger then 01/08/2017!

Let's review this for date 28/06/2017:

((strtoint(@(93,7,10))>2016) or ((@(93,7,10)='2017') and (strtoint(@(93,4,5))>7)) or (((@(93,7,10)='2017') and ((@(93,4,5)='08') and ((strtoint(@(93,1,2))>1) or (@(93,1,2)='01'))))))
( TRUE or ( TRUE and FALSE ) or (( TRUE and ( FALSE and ( TRUE or FALSE )))))
( TRUE or ( TRUE ) or (( TRUE and ( FALSE and ( TRUE )))))
( TRUE or ( TRUE ) or (( TRUE and ( FALSE ))))
( TRUE or ( TRUE ) or FALSE
TRUE or TRUE or FALSE
TRUE (with operator or, only 1 value need true to be true

Based on your condition definition:


Your condition should be like this:

= (strtoint(@(93,7,10))>= 2017) and (strtoint(@93,4,5))>= 8) and (strtoint(@(93,1,2))>= 1)

thank you Jean, I got your point and that helped allot