I am am new to SF and am having a problem building a simple query and am not sure what the problem is. A similar statement works fine in another service. I just want to compare two dates but I keep getting an error that the criterion is not a date and should not be enclosed in quotes. I'm sure the answer is really simple.

        Integer endPadTime   = (DAY_IN_MILLI * POST_DAYS);
        Long currentTime  = Datetime.now().getTime();
                
        Datetime endDate   = Datetime.newInstance( currentTime + endPadTime );

        String queryString =
                            'select id, name, status__c, account__c, alias__c, out_of_service_date__c, ' +
                            'model_number__c, serial_number__c, unque_id__c ' +
                            'from EF_Equipment__c ' +
                            'where out_of_service_date__c < \'' + endDate.format('yyyy-MM-dd') + '\'';  // the problem is here

Thanks

I am am new to SF and am having a problem building a simple query and am not sure what the problem is. A similar statement works fine in another service. I just want to compare two dates but I keep getting an error that the criterion is not a date and should not be enclosed in quotes. I'm sure the answer is really simple.

        Integer endPadTime   = (DAY_IN_MILLI * POST_DAYS);
        Long currentTime  = Datetime.now().getTime();
                
        Datetime endDate   = Datetime.newInstance( currentTime + endPadTime );

        String queryString =
                            'select id, name, status__c, account__c, alias__c, out_of_service_date__c, ' +
                            'model_number__c, serial_number__c, unque_id__c ' +
                            'from EF_Equipment__c ' +
                            'where out_of_service_date__c < \'' + endDate.format('yyyy-MM-dd') + '\'';  // the problem is here

Thanks

Hi All,

I am using CMSForce to build content of one of my current sites and am also using a URL rewriting class. The issue I am having is when using the submit button on a webform page, or calling any pagereference method, the URL rewriter class is called first and the method to save the form never gets executed. Has anyone run into similar issues using URL rewriter, and if so - have you found any workarounds? I appreciate any help with this!

I just installed CMSForce in development as a trail before I go forth with production...

The first 6 steps of the installation process are concerning. We have way too many documents, dashboards, letterheads, workflows etc that we already have set up in Salesforce. I do not want any existing settings changed that would impact their current function.  Can you verify before I install to production? Thanks!

1. Change the visibility settings for any installed documents, reports, dashboards, letterheads, email templates, and custom fields on standard objects. By default, these components are visible to all users. Set the Running User for any installed dashboards or analytic snapshots; by default, it is set to you.
2. Set the Running User for any installed dashboards or analytic snapshots; by default, it is set to you.
3. Specify the appropriate recipients for any installed workflow tasks.
4. Specify the appropriate assignees for any installed workflow alerts.
5. Specify the appropriate user for workflow field updates that modify the Owner field or user lookups; by default, it is set to you.
6. Create a schedule for any installed analytic snapshots.
7. Configure any additional settings for this package from the package detail page.
8. Deploy the package by clicking Deploy Now below. You can also do this at any time in the future from the package detail page.