ContributionsMost RecentMost LikesSolutionsFunction to return the period associated with a date, when the period is 4-4-5 or 5-4-4 Has anyone written a complex expression that takes a date as an input, and determines the period associated with the date, when periods are not based on calendar ends (for example, 4-4-5, or 5-4-4)? ...Re: Question about Complex Expressions built on Connector Data Sources Hi MardayT, in my connector business rules, I use Replace statements to remove commas from all fields that might contain it. Then, you can use the args.line.split command in complex expressions to re...Re: Question about Complex Expressions built on Connector Data Sources Thank you JackLacava, you've confirmed my suspicions. In my case, it sounds like I need to either move the work done in the complex expressions to the Connector rule itself, or "cleanse" the data in ...Question about Complex Expressions built on Connector Data Sources When building a Data Source bound to a Connector business rule, if a need arises to use a Complex Expression, and that expression requires referencing several unbound fields, what is the proper state...Re: Two Double Quotes in Delimited Data Sources Hi Krishna, I ended up writing a RegEx statement within the workflow automation rule I wrote to read each line in the file, find and replace the offending string, and write the dataset to a new file....Two Double Quotes in Delimited Data Sources Hey everyone. We are implementing a use case for a client that requires import of transactional data found within a csv file. The data is comma delimited, and enclosed in quotes. For example, if the ...Re: Mass Deletion option in RCM Groups Hi Sathish, yes, that would be my understanding. I would first delete from the Access Group Members table, as I'm not sure the DB is configured with a cascading delete. Then I would delete from the A...Re: Mass Deletion option in RCM Groups Hi Sathish, I'm not aware of a feature available through the UI. If your company allows it, it would be possible to write a database script that performs a deletion from the Access Groups table, of g...Re: Mass Deletion option in RCM Groups Hi Sathish, do you mean user groups or access groups? Re: Export Account Reconciliation Inventory List In version OFCpv640sv100 and prior (including versions where RCM was installed independently), go to the Update page. There, click the button. Starting in OFCpv660, the behavior has changed!
