Remove timestamp in maptips...

Permanently deleted user

July 27, 2016 23:31

I am pulling date data into my maptip from a sql table through a data connection. The date field in sql is just 'date' not 'datetime', however the time still shows up in the map tip. Is there a way to disable this?

 

0

• 

  John Nerge

  July 29, 2016 13:22

  If you're pulling it through a data link, a quick solution would be to cast the date in your query to varchar so it will be treated as a literal string.

  0
• 

  Permanently deleted user

  July 29, 2016 18:29

  Thank you John...so I"m thinking it should look something like this...

   

  SELECT pk, (CONVERT(VARCHAR(10), Hazmat_date, 20), SiteDoc_date, Asb_date, Debris_date, Confirm_date, Confirmation, Erosion_date, Final_date, isHazMatDateFilled, isSiteDocDateFilled, isAsbDateFilled, isDebDateFilled, isConfirmDateFilled, isErosionDateFilled, isFinalDateFilled, Link FROM ECData.dbo.TB_Erskine_CleanupStatus WHERE Link = @FID

   

  But now the map tip is just blank. I'm not familiar with SQL at all so it's just trial and error at this point...Can you point me in the right direction?

  0
• 

  John Nerge

  July 29, 2016 21:22

  If you're going to put your CONVERT inside of parentheses, then you need a closing one too:

   

  (CONVERT(VARCHAR(10), CaseDate, 20))

   

  OR

   

  CONVERT(VARCHAR(10), CaseDate, 20)

   

  I always test my data link syntax in SQL Server first to make sure I get results back. Geocortex Essentials doesn't tell you if there's an error in your query. The records just don't show up.

  0

Please sign in to leave a comment.