Introducing the all-new TIBCO Community site!

For current users, please click "Sign In" to reset your password and access the enhanced features. If you're a first-time visitor, we extend a warm welcome—click "Sign Up" to become a part of the TIBCO Community!

If you're seeking alternative community sites, explore ibi, Jaspersoft, and Spotfire.

Jump to content

Date/Time Fail


Kimberly Wargo

Recommended Posts

Hi all, I have a Integration Flow that is failing in multipe date fields.

My formula reads like this:

DATE(PARSE(FAAccountImport.OpenDate,3,"/"),PARSE(FAAccountImport.OpenDate,1,"/"),PARSE(FAAccountImport.OpenDate,2,"/"))

It is a Date/Time to Date field.

Here is my error:

Operation failed. Label: Upsert EAST_FinancialAccount__c, Name: EAST_FinancialAccount__cUpsert, Message: Exception Type : FormatException Message : Input string was not in a correct format. StackTrace : at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal) at System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info) at Scribe.Process.ProcessImportedFinancialAccountImportNew.Execute(Dictionary`2 settings, IEnumerable`1 dataEntityInput) :Error in mapping 'EAST_FinancialAccount__c.DateOpened__c ' for Operation 'Upsert'"

 

Any suggestions are appreciated.

Thanks

Kim

Link to comment
Share on other sites

When using TCI Connect/Scribe integration Flows:

You can validate your input data field in two ways to check for nulls/empty fields to avoid your formulas to fails.

1) By using an IF ELSE block and check for empty fields or other evaluatuon criteria to make sure your field has expected data to avoid errors in your formulas.

i.e. only when your evaluation equals boolean true or false, then add your operation block (CREATE or UPDATE BLOCKS) to the IF or the ELSE part of the condition.

 

2) You can also Add IFconditions in your formulas as well, have a look at the built in excel like functions/formulas with the related inline documentation with examples.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...