Hello,

You can use the following filtering:
$filter=CreatedOn ge 2024-08-05T00:00:00Z

https://documenter.getpostman.com/view/10204500/SztHX5Qb?version=latest

Hello,
 

Unfortunately, there is no out-of-the-box functionality to implement a DateTime field that ignores the user's time zone settings. To achieve this, custom development would be required.

Best regards,
Ivan

do you have your Time Zone Set for your Profile?

Hello Keith.

I dont believe this is a Time-Zone problem.

For the same user, if I choose Activity of category Task, everytih works as it should be. 

Thanks

Which error message do you get in the console from the client-side when opening a record? Also which value is being stored in the database. Finally, what does this.get("BirthDate") returns inside the onEntityInitialized method execution from the client-side?

Best regards,

Oscar

Hi Bhoobalan,

Please use the column validator instead that will do the same task:

setValidationConfig: function() {
              this.callParent(arguments);
              this.addColumnValidator("UsrDatetime1",this.dateTimeColumnValidator);
            },
          	dateTimeColumnValidator: function(){
              console.log(this.get("UsrDatetime1"));
              var invalidMessage = "";
              console.log(this.getSysDefaultValue(Terrasoft.SystemValueType.CURRENT_DATE_TIME));
              if (this.get("UsrDatetime1")>this.getSysDefaultValue(Terrasoft.SystemValueType.CURRENT_DATE_TIME)){
               	invalidMessage = this.get("Resources.Strings.ErrorMessage");
              } 
                return {
                  invalidMessage: invalidMessage
                };
              },

Just replace the UsrDatetime1 column with your date\rime column name and also create a localizable string with the "ErrorMessage" code.

Best regards,

Oscar

Oscar Dylan,

Thanks much for the precious response!



But still we could select the future date value, And after validation we throw a error message below the corresponding field name. 



We need to block selecting the future date, which could be possibly achieved via Jquery as below,

$("#dateField").datepicker({

    maxDate: 0

});

How could we achieve the same in our CREATIO Date field ?





Regards,

Bhoobalan P.

Bhoobalan Palanivelu,

This validator will also return a validation message upon saving a record with an incorrect date, so it's not possible to select the date\time grater than the current date\time:

And this is much easier than creating a custom logic for the date selector modal window so please use this approach.

Best regards,

Oscar

Hi Raz, 

Could you please provide a full script-task code you use so we will be able to test it at our end?

Regards,

Anastasiia

Hello Heather,

Please go to configurations and find the object that represents the section where the date\time field was added. Open this object and find your date\field column there, click on it and select displaying all column properties:

Once done please change the data type to "Date":

and save and publish the object once it is done. As a result you will see only dates in this column.

Best regards,

Oscar

Thank You!!!!!

Hello Toan!



Please double check if the "UsrSentAt" attribute has DATE type. 

Also, you should pass the value as it is, not creating the object.

this.set("UsrSentAt",   today );

For example:

I have created attribute 

"Date": {

                dataValueType: Terrasoft.DataValueType.DATE,

                type: Terrasoft.ViewModelColumnType.VIRTUAL_COLUMN

              }



And I was able to successfully set it :

onEntityInitialized: function(){

                this.callParent(arguments);

                debugger;

                var date  = new Date();

                this.set("Date", date);

            }

Hi Alex,

Thanks for replying, see my screenshoot

Toan Mai,

Anyway, example that I sent above should work. Just pass the raw value in the set function instead of new object. 

this.set("UsrSentAt",   today );