Wrong data being wrote to SQL

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

Alexey Shmelkin (sysberry-absc.com)

October 10, 2019 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

Wrong data being wrote to SQL

Comments

Didn't find what you were looking for?