Issues filtering tags that contain dates

[motivatedgorilla]

I'm using an EAP project file and have attempted to filter tags that contain dates. For some odd reason or the other Sparx appears to store dates in 2 formats e.g. 01 May 2014 or 01/05/2014 (DD/MM/YYYY).

The query is as below returns no results even though there are tags that fall within that range

Code: [Select]

SELECT o.ea_guid as CLASSGUID, o.Object_Type as CLASSTYPE,
       o.Name, type.Property, type.Value
FROM ((t_object as o
       INNER JOIN t_objectproperties as location
         ON o.Object_ID = location.Object_ID)
       INNER JOIN t_objectproperties as type
         ON o.Object_ID = type.Object_ID)
WHERE location.Property = 'Location'
  AND location.Value = 'ND'
  AND type.Property = 'FDate'
  AND CDate(type.Value) >= CDate('01/05/2014')
  AND CDate(type.Value) <= CDate('05/05/2014')

[Eve]

At a guess I would say that EA has incorrectly saved the date in the local format instead of a system independent format.

[motivatedgorilla]

Thanks Simon. How do i resolve the issue?