Wrong data being wrote to SQL

追蹤

Gwen Wilson

• 2019年10月09日 20:11
• 編輯於

Hi, when I write out my dates to SQL, they are incorrect (a day behind). I remember my AP instructor saying this was an issue with browser applications in general. But I can't remember if he mentioned a fix or how to get the correct dates (I can't find it in my notes). I would just add a day, but is it a conversion from GMT or something where it may occasionally insert the correct date (just depending on the time of day)?

I'm doing a convert date format to get them into MM/dd/yyyy and in SQL it's a text field. 

Thanks!

Gwen

0

• 

  sysberry GmbH

  • 2019年10月10日 11:01

  Hi Gwen,

  if you use AgilePoint v7 SU 1 or earlier, than you don't have a fix for that. Go to advanced properties of the date control and check the checkbox "store the data not in ISO format" or something like that. Than it should work.

  Regards,
  Alexey

  0

  評論操作 永久連結

請登入寫評論。