I have a custom field with data type "Date" and when I run a query in the dev console the date returns as expected
SELECT customfield_date__d from myobject 2017-10-03
When I query against the custom object using a List in Apex the field in the List is now in DateTime
List<myobject> myrows = [SELECT customfield_date__d from myobject]
If I display the field in the log (system.debug()), the results is strange; the "T" and ".000Z" are removed
system.debug(myrows.customfield_date__d); 2017-10-04 00:00:00
I'm not exactly clear on all the conversion going on, but the result I need is the custom field in date format
I need to compare the date to 60 days ago for all the rows in myobject and with all these conversions I"m getting stuck on how to proceed.