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

  评论操作 固定链接

请先登录再写评论。