Spectrum Spatial (SSA/LIM)

 View Only

  • 1.  Spectrum Spatial queries

    Posted 09-25-2019 01:52
    Hi everyone
    I seem to be having a bit of an issue with some dates on which I want to run a query in SSA.
    The table is located in sql server and the field "Assessment date" and "Completed date" are of the type Date/Time.

    Mapinfo sees them as date/time and ssa sees them as date/time, which is all good until, I want to run a query between 2 dates like
    Completed date >= 01/02/2008 and completed date <= 01/04/2008

    The form I have in ssa for the table sees the date /time and wants a date and a time input, which is not really what I require, I want just the date only not the date/time.

    If I change the fields from date/time in sql to date mapinfo then sees them as a character field not date field and so does SSA.

    Has anyone got any work around for this so both Mapinfo and SSA see them as date fields, and I can run queries on them as dates only.

    Any suggestions welcome.

    ------------------------------
    Russell Ferguson
    Ararat Rural City Council
    Ararat
    ------------------------------


  • 2.  RE: Spectrum Spatial queries

    Employee
    Posted 09-29-2019 20:25
    Hi Russell,

    Your query is being looked after under the Tech Support case now.
    We will make sure that your query is resolved and then share the response on this page as well.

    Thanks!

    ------------------------------
    Ruchi Mishra
    Pitney Bowes Australia Pty Ltd
    Melbourne
    ------------------------------

    Original Message