2 Replies Latest reply: Apr 21, 2015 3:24 AM by Vinay Rao RSS

    Salesforce.com Date Format in Script Date Variable

      I'm connecting to SFDC via the Qlikview API.  The format of the "Created Date" field in the EVENT object looks like this:

       

      2015-01-01T00:00:00.000Z

       

      I'm trying to create a variable to use instead which pulls for the last 6 months.  I've tried the formula below, but it's not working...

       

      Let  vDate = TimeStamp((Floor(AddMonths(Today(),-5)) - Floor(Day(Today()))+1),'YYYY-MM-DD 00:00:00');

       

      When I run the script it just appears "frozen", instead of running the query.  Any thoughts?

       

      Thanks,  Dan