Idea is to keep the display format separate from the scripting format. You can use any format that you like in Display format and will not interfere with the script. In the script I would always like to use "YYYY-MM-DD" the international format which you do not have to worry about as long as you set...

Irrespective of the display pattern/format I would use the following FormCalc code in your situation. Also check the attachment.'exit' event of the DateFrom:if (Date() <= Date2Num($.rawValue, "YYYY-MM-DD")) then //xfa.host.setFocus("xfa.form.form1.DateTo") var v1 v1=1else xfa.host.setFocus("xfa.form...

Your requirement is tricky and very challenging (I like the stuff). Check the attachment here is what I have done.........1. Set the Binding to Normal2. Added FormCalc code to the "exit" event of the Table1:Column1:txtMaterialComp Here is the script var partLeftvar partRightpartLeft = Substr($.somEx...

This is a setting on individuals machine...........you need to turn off "Auto Complete". Set this to Off @ Edit>>Preferences>>Categories:Forms:Auto-Complete.

The simple answer is 'FeldName.rawValue = "";' simply include the line of code for each field that you want to clear the value with in the same code that makes them hidden.Good Luck,

If you are looking to update Tool Tip you do that in "Accessibility" pallet. You could use Window>>Accessibility or Shift+F6 to open it. Hope that helps.

Improved again to fix other possible issues...........var timeStampvar timeOutvar timeInvar Catvar timep1var timep2var timep3var timep4var StartIntervalif (HasValue($.parent.OUTA1[0]) and HasValue($.parent.INA1[0])) then timeStamp = $.parent.OUTA1[0].formattedValue Cat = At(timeStamp,":") timep1 = ...

Here you go....... It was silly mistake on my part....... messed up with syntax. FormCalc do not like "{, }"  instead we use "Then, Endif"var timeStampvar timeOutvar timeInvar Catvar timep1var timep2var StartIntervalif (HasValue($.parent.OUTA1[0]) and HasValue($.parent.INA1[0])) then timeStamp = $.p...

your attachment says queued....... I am not able to open it. Would you mind email your template to "n_varma AT lycos.com".

I would change your FormCalc script to look like this..........var timeStampvar timeOutvar timeInvar Catvar timep1var timep2var StartIntervalif (HasValue(OUTA1[0]) and HasValue(INA1[0])) { timeStamp = OUTA1[0].rawValue //OUTA1[0].formattedValue Cat = At(timeStamp,":") timep1 =  Left(timeStamp, Cat-1...