Skip to main content
Salesforce

Return to Question

added 3 characters in body
Source Link
Ayush Goyal
Ayush Goyal
  • 455
  • 1
  • 6
  • 20

I have a field on a custom setting which is of the type DateTime. I have a business requirement where I need to use this value in conditional SOQL of one SObject.

If I try to use Select Id, myField__c FROM MySampleObject__c WHERE SystemModStamp > myDateTimeValue , the SOQL statement throws compile time error.

Is it some data type issue or is it not comparable to variables?

I have a field on a custom setting which is of the type DateTime. I have a business requirement where I need to use this value in conditional SOQL of one SObject.

If I try to use Select Id, myField__c FROM MySampleObject__c WHERE SystemModStamp > myDateTimeValue , the SOQL statement throws compile time error.

Is it some data type issue or is it not comparable variables?

I have a field on a custom setting which is of the type DateTime. I have a business requirement where I need to use this value in conditional SOQL of one SObject.

If I try to use Select Id, myField__c FROM MySampleObject__c WHERE SystemModStamp > myDateTimeValue , the SOQL statement throws compile time error.

Is it some data type issue or is it not comparable to variables?

Source Link
Ayush Goyal
Ayush Goyal
  • 455
  • 1
  • 6
  • 20

Is SystemModStamp field comparable to variables of DateTime data type in SOQL statements?

I have a field on a custom setting which is of the type DateTime. I have a business requirement where I need to use this value in conditional SOQL of one SObject.

If I try to use Select Id, myField__c FROM MySampleObject__c WHERE SystemModStamp > myDateTimeValue , the SOQL statement throws compile time error.

Is it some data type issue or is it not comparable variables?