dates | Community Creatio

06:51 Nov 18, 2024

Hi all,

I'm trying to calculate 60 days before a date captured by the user to create a reminder. I'm using the Formula in the Business Process but I cannot make it work, I see the following error: Formula value error: Cannot convert type "Int32" to "Entity"

Any suggestion?

Thank you

2 comments

Harvey Adcock

10:39 Nov 18, 2024

It looks like it's an issue with trying to set the parameter you've selected to the value of the formula - what is the type of the paramete...MoreLess

Show all comments (1)

Validation

dates

amount

Validation low code/no code

Arkadiusz Polus

11:14 Dec 05, 2022

How can I set such validations

1. The "Date To" of an event should come after the "Date From"

2. The date should not be in the past

3. The amount should not be less than 0

4 comments

Nicolaiciuc Maria

13:29 Dec 05, 2022

Hello Arkadiusz Polus, in order to perform this kind of validation you need to write a little bit of code in the schema page. Perhaps this article...MoreLess

Arkadiusz Polus

13:31 Dec 05, 2022

what about business rules?

Nicolaiciuc Maria

14:17 Dec 05, 2022

Arkadiusz Polus,

Business rules do not permit these operators >, >=, <, <=, so it would not be possible to solve these three cases that you mentioned earlier.

Damien Collot

10:40 Dec 06, 2022

Maybe something that should be included in business rules in the future ? ?

Show all comments (3)

Unable to send date updates to Creatio

Jerry Holt

12:08 May 08, 2022

Has anyone been successful using the CreatioSDK in sending date updates via either InsertQuery or UpdateQuery?

I've tried sending dates in all the following formats but all result in an error:

yyyy-MM-dd

yyyy-MM-ddTHH:mm:ss

yyyy-MM-ddTHH:mm:ss.fff

yyyy-MM-ddTHH:mm:ss.fffffffZ

M/d/yyyy

d/M/yyyy

dd/MM/yyyy

The...MoreLess

1 comments

Best reply

Roman Brown

13:02 May 08, 2022

Hello Jerry,

Please try to pass Date into Creatio with the following format in UTC time:

      "dataValueType":8,
      "value":"\"2000-01-01T00:00:00.000\""

Kind regards,
Roman

Show all comments

oData

dates

OData: get dates in UTC?

Massimiliano Mazzacurati

10:27 Jan 21, 2022

Hello everybody

When we request section data via OData the date fields are returned with the authenticated user time-zone setting and not UTC.

Is there a way to obtain date fields in UTC via OData, regardless authenticated user time-zone?

Thanks

1 comments

Oleg Drobina

11:14 Jan 24, 2022

Hello,

The only way to achieve your business task is to create a separate user that will be used in OData requests authentication, set the...MoreLess

Show all comments

11:23 Jan 29, 2020

Dear mates,

How can i format date in Creation source code ?

When i do this:

var esq = this.Ext.create("Terrasoft.EntitySchemaQuery", {
   rootSchemaName: "Order"
});
 
esq.addColumn("Date");
 
esq.getEntityCollection( function(result) {
    result.collection.each ( function (order) {
       this.console.log(Date);
    });
});

the system return me:

function Date() { [native code] }

What the way to format Date ?

Thanks,

Nicolas

2 comments

Alina Kazmirchuk

18:46 Feb 06, 2020

The Date can be formatted via default js functions. Please feel free to find out more about working with Date in JavaScript in the article...MoreLess

Show all comments (1)

Set date to NULL in process

LÉZORAY Nicolas

09:34 Nov 20, 2019

Dear mates,

I'd like to set a date to null in a process. I tryed several ways but it never worked.

Is it possible to do this in a process or should i do it in JS ?

Thanks,

Nicolas

3 comments

LÉZORAY Nicolas

12:44 Nov 20, 2019

Well i did it in js:

onEntityInitialized: function() {

...MoreLess

Angela Reyes

00:53 Nov 25, 2019

LÉZORAY Nicolas,

You can create date parameter and leave it empty. Then specify this parameter as a value that must be inserted to date field...MoreLess

LÉZORAY Nicolas

13:05 Dec 02, 2020

Thank you it works !

Show all comments (2)

Does Bpmonline spports Hijri Calender

sdeen@isb-me.com

14:37 Oct 23, 2019

Hello

I know that Bpmonline supports Gregorian Calendar, what about supporting other calenders like (Hijri Calendar)

Regards

1 comments

Dean Parrett

13:44 Oct 28, 2019

Hello,

Unfortunately, by default there are no any other calendars or Hijri Calendar time format. If you need to set up the new calenda...MoreLess

Show all comments

Formula for subtracting date and converting the defference to integers

aaykay

10:40 May 20, 2019

Hi,

I am trying to build a process that will subtract 2 dates and record the difference in an integer field for all the records in the CRM. But for some reason, I can not get the result as required.

14 comments

Dennis Hudson

04:39 May 21, 2019

Hello,

Formula value uses standard C# syntax. In your case subtraction of 2 datetime fields gives you a TimeSpan, you can get the number...MoreLess

aaykay

05:10 May 21, 2019

Dennis Hudson,

Thanks for the reply. I am trying to build a business process to run every morning and that process should read the tw...MoreLess

Dennis Hudson

05:28 May 21, 2019

aaykay,

There are 2 options how you can do that:

1) You can add a boolean column to your object (Something like Processed) and loop through...MoreLess

aaykay

05:35 May 21, 2019

Dennis Hudson writes:

You can add a boolean column to your object (Something like Processed) and loop through all records, which have processed...MoreLess