FormCalc IF-Statement doesnt work | Community
Skip to main content
A
Anonymous
November 6, 2013
Solved

FormCalc IF-Statement doesnt work

  • November 6, 2013
  • 4 replies
  • 4442 views

 Why does it don't work correctly? Does Formcalc cant handle 2 Statements? It doesnt handle the Datefiled correct...
  
if 
 ( ( FORM_INTERFACE.DATE.formattedValue <= "01.01.2014" ) and
    ( FORM_INTERFACE.NUM eq "0271" 
  or FORM_INTERFACE.NUM eq "0272" 
  or FORM_INTERFACE.NUM eq "0413" ) ) 
then
 $.presence ="visible"
 else.
 $.presence = "hidden"
 endif,
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by jasotastic81

this works

if (($.rawValue <= "2014-01-01") and (TextField1.rawValue eq "0271" or TextField1.rawValue eq "0272" or TextField1.rawValue eq "0413"))

then TextField2.rawValue = "less and right"

else TextField2.rawValue = "more or wrong"

endif

Change the commands to whatever you need, but that if statement works just fine.

4 replies

jasotastic81
jasotastic81
Level 8
November 6, 2013

I'm not sure what you mean by "it's not handling the datefield correctly."

Just looking at the code you provided, I would presume that it's not performing the logic the way you want. It should be evaulating "01.01.2014" like it would letters--one number at a time. (e.g., "flask" > "flash" because "k" > "h".) In the same way, "01.01.2013" < "01.01.2014" since all of the numbers are the same until the end, but "10.01.2013" > "01.01.2014" because "1" > "0". Is that what's happening? If so, format your date as yyyy.mm.dd so that you sort by year first. 2014 is after 2013 no matter what month or date, and "2014" > "2013" no matter what comes after it.

If that's not what you meant, please provide some more detail.

A
Anonymous
November 6, 2013

the field date is provided by an xml-interface from sap webdynpro.

In sap all date-field are internal written as : 'YYYYMMDD'. (i suppose this is the rawValue in Adobe).

On a screen the filed is displayed as: 'DD.MM.YYYY'. (formattedValue in Adobe ?).

In SAP Abap it would by no problem to check if the date is below 1.1.2014.

If date le '20140101'.

...

endif.

How i check this in FormCalc? I checked the FormCalc User Reference, but examples are hard to come by.

Also I must check 2 things togehter:

Date lt 1.1.2014 & number 271,272,413->hidden

Date ge 1.1.2014 & number 271,272,413->visible

Date lt 1.1.2014 & number NE 271,272,413->visible

Date ge 1.1.2014 & number NE 271,272,413->visible

jasotastic81
jasotastic81Accepted solution
Level 8
November 6, 2013

this works

if (($.rawValue <= "2014-01-01") and (TextField1.rawValue eq "0271" or TextField1.rawValue eq "0272" or TextField1.rawValue eq "0413"))

then TextField2.rawValue = "less and right"

else TextField2.rawValue = "more or wrong"

endif

Change the commands to whatever you need, but that if statement works just fine.

A
Anonymous
November 6, 2013

cool, seems to work :-)

rawValue < "2014-01-01" ->that was the solution...

Thanks very much.

Terms & ConditionsAccessibility statement

Loading footer...