<div dir="ltr"><div>After adding some extra debug messages, the date format conversion is occurring, just not being passed to the query.<br></div><div><br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">2024-12-24T11:41:20-06:00 DEBUG VT <b>Entering getValidDBInsertDateValue(12-24-2024) method </b>...<br>2024-12-24T11:41:20-06:00 DEBUG VT <b>Entering convertToDBFormat(12-24-2024) method</b> ...<br>2024-12-24T11:41:20-06:00 DEBUG VT<b> __convertToDBFormat is returning '2024-12-24'</b><br>2024-12-24T11:41:20-06:00 DEBUG VT Exiting getValidDBInsertDateValue method ...<br>2024-12-24T11:41:20-06:00 DEBUG VT Entering function get_column_value (cf_817, , cf_817, 21, V='')<br>2024-12-24T11:41:20-06:00 DEBUG VT Exiting function get_column_value<br>2024-12-24T11:41:20-06:00 DEBUG VT Entering function get_column_value (cf_823, , cf_823, 16, V='')<br>2024-12-24T11:41:20-06:00 DEBUG VT Exiting function get_column_value<br>2024-12-24T11:41:20-06:00 DEBUG VT Entering function get_column_value (cf_841, , cf_841, 21, V='')<br>2024-12-24T11:41:20-06:00 DEBUG VT Exiting function get_column_value<br>2024-12-24T11:41:20-06:00 DEBUG VT Entering function get_column_value (cf_980, , cf_980, 21, V='')<br>2024-12-24T11:41:20-06:00 DEBUG VT Exiting function get_column_value<br>2024-12-24T11:41:20-06:00 DEBUG VT Entering function get_column_value (internal_comment_was_added, , internal_comment_was_added, 1, V='')<br>2024-12-24T11:41:20-06:00 DEBUG VT Exiting function get_column_value<br>2024-12-24T11:41:20-06:00 DEBUG VT Prepared sql query being executed : UPDATE vtiger_ticketcf SET cf_825=?,cf_815=?,cf_779=?,cf_833=? WHERE ticketid=?<br>2024-12-24T11:41:20-06:00 DEBUG VT <b>Prepared sql query parameters : [12-24-2024 10:35:00,2024-12-24,0,150,2798075]<br></b></blockquote><div><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><br></div><table cellpadding="0" cellspacing="0" style="font-family:Arial,sans-serif;font-size:14px;color:rgb(51,51,51)"><tbody><tr><td style="display:flex"><b><img src="https://media.glassdoor.com/sql/640156/retail-data-systems-squarelogo-1412104178471.png" alt="RDS Logo" style="width:60px;height:60px;margin-right:10px"></b><div><b>Steve Kenow</b><br><span style="font-style:italic;font-size:12px">Manager, End-User Services and Support - <a href="https://www.rdspos.com/Minneapolis-Minnesota-Grocery-Point-of-Sale-System" target="_blank">RDS MN</a></span><br><span style="font-size:12px;display:inline-block">Direct: (952) 392-2686<br>Office: (952) 934-4001<br>Email: <a href="mailto:skenow@rdspos.com" style="color:rgb(17,85,204)" target="_blank">skenow@rdspos.com</a></span></div></td></tr><tr><td><table cellpadding="0" cellspacing="0"><tbody><tr><td><br><table cellpadding="0" cellspacing="0"><tbody><tr><td><table cellpadding="0" cellspacing="0" style="margin-top:10px"><tbody><tr><td><a href="https://mailtrack.io/trace/link/d5e46ac8cfdec7b8ebdc539696dd45306644b800?w=anNrb2xha0ByZHNwb3MuY29t&url=https%3A%2F%2Fwww.rdspos.com%2FProducts-Solutions%2FGrocery&userId=3091118&signature=18b062316c510b1b" style="color:rgb(17,85,204)" target="_blank"><img src="https://www.rdspos.com/portals/0/Icon-Shopping-Cart2.jpg" alt="Icon 1" style="width:30px;height:30px;margin-right:10px"></a></td><td><a href="https://mailtrack.io/trace/link/b0fdfdd837e0d187e174cae0c9479c9b847c4e36?w=anNrb2xha0ByZHNwb3MuY29t&url=https%3A%2F%2Fwww.rdspos.com%2FProducts-Solutions%2FQuick-Service%2FPoint-of-Sale-Solutions&userId=3091118&signature=b26cf2b23255a2a2" style="color:rgb(17,85,204)" target="_blank"><img src="https://www.rdspos.com/portals/0/Icon-Burger2.jpg" alt="Icon 2" style="width:30px;height:30px;margin-right:10px"></a></td><td><a href="https://mailtrack.io/trace/link/9c1116af49d5de3a851b38185dbd7ba07d27def2?w=anNrb2xha0ByZHNwb3MuY29t&url=https%3A%2F%2Fwww.rdspos.com%2FProducts-Solutions%2FRestaurant%2FPoint-of-Sale-Solutions&userId=3091118&signature=78db9a7d4392c7ed" style="color:rgb(17,85,204)" target="_blank"><img src="https://www.rdspos.com/portals/0/Icons-TableService2.jpg" alt="Icon 3" style="width:30px;height:30px;margin-right:10px"></a></td><td><a href="https://mailtrack.io/trace/link/c5c6a63b04b163898650fb7e2fdd7312ca923cdf?w=anNrb2xha0ByZHNwb3MuY29t&url=https%3A%2F%2Fwww.rdspos.com%2FProducts-Solutions%2FGeneral-Retail&userId=3091118&signature=1ec7a1d9db94a0f1" style="color:rgb(17,85,204)" target="_blank"><img src="https://www.rdspos.com/portals/0/Icons-Retail2.png" alt="Icon 4" style="width:30px;height:30px;margin-right:10px"></a></td><td><a href="https://mailtrack.io/trace/link/9d0a121b09b0d5e1ba1c5be04c5c2b8d969b7d2c?w=anNrb2xha0ByZHNwb3MuY29t&url=https%3A%2F%2Fwww.rdspos.com%2FProducts-Solutions%2FConvenience-Store%2FNCR-Radiant-Convenience-Store-POS-System&userId=3091118&signature=112f29b42fe5a787" style="color:rgb(17,85,204)" target="_blank"><img src="https://www.rdspos.com/portals/0/Icon-Fuel2.jpg" alt="Icon 5" style="width:30px;height:30px;margin-right:10px"></a></td><td><a href="https://mailtrack.io/trace/link/16b4ffb1c4363203009e09666cb41ce82f3a39c1?w=anNrb2xha0ByZHNwb3MuY29t&url=https%3A%2F%2Fwww.rdspos.com%2FProducts-Solutions%2FRDS-Payment-Services&userId=3091118&signature=84ffb1248e80fb55" style="color:rgb(17,85,204)" target="_blank"><img src="https://www.rdspos.com/portals/0/Icon%20-%20Credit%20Card%20processing.png" alt="Icon 6" style="width:30px;height:30px;margin-right:10px"></a></td></tr></tbody></table><hr style="width:240px;height:1px;margin-top:10px;margin-bottom:6px;background-color:rgb(170,170,170)"><div><br></div></td></tr></tbody></table><font size="2">Support Questions/Issues? Email <a href="mailto:rdshelp@rdspos.com" target="_blank">rdshelp@rdspos.com</a> (non-emergencies) or call (952) 934-4002 24/7</font></td></tr></tbody></table></td></tr></tbody></table></div></div></div><br></div><br><div class="gmail_quote gmail_quote_container"><div dir="ltr" class="gmail_attr">On Fri, Dec 20, 2024 at 3:50 PM Steve Kenow <<a href="mailto:skenow@rdspos.com">skenow@rdspos.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div>Thanks, Patrick.</div><div><br></div><div>I changed the displaytype to 2 (it was 1), and the value was not changed when I edited the record - as desired. However, on a ticket where the value hadn't been set and the status field changed to 'Closed', it wasn't updated by the workflow - not as desired. <br></div><div><br></div><div>Changing the displaytype to 3 hid the field completely.</div><div><br></div><div>I still have the uitype as 70, which is how the system datetime fields are configured. I'll test your suggestions in combination with the displaytype options.<br clear="all"></div><div><div dir="ltr" class="gmail_signature"><div dir="ltr"><div><br></div><table cellpadding="0" cellspacing="0" style="font-family:Arial,sans-serif;font-size:14px;color:rgb(51,51,51)"><tbody><tr><td style="display:flex"><b><img src="https://media.glassdoor.com/sql/640156/retail-data-systems-squarelogo-1412104178471.png" alt="RDS Logo" style="width: 60px; height: 60px; margin-right: 10px;"></b><div><b>Steve Kenow</b><br><span style="font-style:italic;font-size:12px">Manager, End-User Services and Support - <a href="https://www.rdspos.com/Minneapolis-Minnesota-Grocery-Point-of-Sale-System" target="_blank">RDS MN</a></span><br><span style="font-size:12px;display:inline-block">Direct: (952) 392-2686<br>Office: (952) 934-4001<br>Email: <a href="mailto:skenow@rdspos.com" style="color:rgb(17,85,204)" target="_blank">skenow@rdspos.com</a></span></div></td></tr><tr><td><table cellpadding="0" cellspacing="0"><tbody><tr><td><br><table cellpadding="0" cellspacing="0"><tbody><tr><td><table cellpadding="0" cellspacing="0" style="margin-top:10px"><tbody><tr><td><a href="https://mailtrack.io/trace/link/d5e46ac8cfdec7b8ebdc539696dd45306644b800?w=anNrb2xha0ByZHNwb3MuY29t&url=https%3A%2F%2Fwww.rdspos.com%2FProducts-Solutions%2FGrocery&userId=3091118&signature=18b062316c510b1b" style="color:rgb(17,85,204)" target="_blank"><img src="https://www.rdspos.com/portals/0/Icon-Shopping-Cart2.jpg" alt="Icon 1" style="width: 30px; height: 30px; margin-right: 10px;"></a></td><td><a href="https://mailtrack.io/trace/link/b0fdfdd837e0d187e174cae0c9479c9b847c4e36?w=anNrb2xha0ByZHNwb3MuY29t&url=https%3A%2F%2Fwww.rdspos.com%2FProducts-Solutions%2FQuick-Service%2FPoint-of-Sale-Solutions&userId=3091118&signature=b26cf2b23255a2a2" style="color:rgb(17,85,204)" target="_blank"><img src="https://www.rdspos.com/portals/0/Icon-Burger2.jpg" alt="Icon 2" style="width: 30px; height: 30px; margin-right: 10px;"></a></td><td><a href="https://mailtrack.io/trace/link/9c1116af49d5de3a851b38185dbd7ba07d27def2?w=anNrb2xha0ByZHNwb3MuY29t&url=https%3A%2F%2Fwww.rdspos.com%2FProducts-Solutions%2FRestaurant%2FPoint-of-Sale-Solutions&userId=3091118&signature=78db9a7d4392c7ed" style="color:rgb(17,85,204)" target="_blank"><img src="https://www.rdspos.com/portals/0/Icons-TableService2.jpg" alt="Icon 3" style="width: 30px; height: 30px; margin-right: 10px;"></a></td><td><a href="https://mailtrack.io/trace/link/c5c6a63b04b163898650fb7e2fdd7312ca923cdf?w=anNrb2xha0ByZHNwb3MuY29t&url=https%3A%2F%2Fwww.rdspos.com%2FProducts-Solutions%2FGeneral-Retail&userId=3091118&signature=1ec7a1d9db94a0f1" style="color:rgb(17,85,204)" target="_blank"><img src="https://www.rdspos.com/portals/0/Icons-Retail2.png" alt="Icon 4" style="width: 30px; height: 30px; margin-right: 10px;"></a></td><td><a href="https://mailtrack.io/trace/link/9d0a121b09b0d5e1ba1c5be04c5c2b8d969b7d2c?w=anNrb2xha0ByZHNwb3MuY29t&url=https%3A%2F%2Fwww.rdspos.com%2FProducts-Solutions%2FConvenience-Store%2FNCR-Radiant-Convenience-Store-POS-System&userId=3091118&signature=112f29b42fe5a787" style="color:rgb(17,85,204)" target="_blank"><img src="https://www.rdspos.com/portals/0/Icon-Fuel2.jpg" alt="Icon 5" style="width: 30px; height: 30px; margin-right: 10px;"></a></td><td><a href="https://mailtrack.io/trace/link/16b4ffb1c4363203009e09666cb41ce82f3a39c1?w=anNrb2xha0ByZHNwb3MuY29t&url=https%3A%2F%2Fwww.rdspos.com%2FProducts-Solutions%2FRDS-Payment-Services&userId=3091118&signature=84ffb1248e80fb55" style="color:rgb(17,85,204)" target="_blank"><img src="https://www.rdspos.com/portals/0/Icon%20-%20Credit%20Card%20processing.png" alt="Icon 6" style="width: 30px; height: 30px; margin-right: 10px;"></a></td></tr></tbody></table><hr style="width:240px;height:1px;margin-top:10px;margin-bottom:6px;background-color:rgb(170,170,170)"><div><br></div></td></tr></tbody></table><font size="2">Support Questions/Issues? Email <a href="mailto:rdshelp@rdspos.com" target="_blank">rdshelp@rdspos.com</a> (non-emergencies) or call (952) 934-4002 24/7</font></td></tr></tbody></table></td></tr></tbody></table></div></div></div><br></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Fri, Dec 20, 2024 at 6:46 AM Alexander Allen <<a href="mailto:alexander.allenz@gmail.com" target="_blank">alexander.allenz@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="auto">Hello. I also use custom field date on Help Desk module. I found similar uses as you. To fix it I set that fields to not display on edit mode (In the vtiger_field table change display time from 1 to 2 or 3, don’t remeber). Also I put the UITYPE as 1 and let Date time as format.</div><div dir="auto"><br></div><div dir="auto">If this also not works, change your table vtiger_ticketcf field forme date time to varchar. If you this, get a backup of your table if something does not work.</div><div dir="auto"><br></div><div dir="auto">I remember that the main key is to not show the field in the Edit Mode.<br clear="all"><br clear="all"><div dir="auto"><div dir="ltr" class="gmail_signature"><div dir="ltr"><img width="420" height="117" src="https://ci3.googleusercontent.com/mail-sig/AIorK4yBdmjOS3mPpyoN3v1oMNsorQHB14uqYh2SXudDQ3eKNI4wf_M5lw2YMsnrgDY4mPzddZ_rHNM6Ldxf"><br></div></div></div></div><div><br></div><div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Fri, Dec 20, 2024 at 04:37 Alan Lord <<a href="mailto:alanslists@gmail.com" target="_blank">alanslists@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">vtiger open source doesn't really have an "editable" datetime field <br>
UIType. The one used for Modified and Created time values is really only <br>
a read-only field type.<br>
<br>
I had to create a custom UItype field for one customer who really wanted <br>
an editable datetime field. You will also need a different UX library to <br>
let you edit it in Detail and Edit Views. FWIW I used a small library <br>
called FlatPickr. Honestly it was a right PITA and took me ages to get <br>
all the possible ways a user could edit/view it to work properly in <br>
multiple timezones.<br>
<br>
<br>
Al<br>
<br>
<br>
On 19/12/2024 23:02, Steve Kenow wrote:<br>
> Login and set calendar preferences to mm-dd-yyyy<br>
> Navigate to a closed ticket<br>
> Edit - make no changes<br>
> Save<br>
><br>
> Result: Closed Date (cf_825) is saved as 0000-00-00 00:00:00<br>
<br>
_______________________________________________<br>
<a href="http://www.vtiger.com/" rel="noreferrer" target="_blank">http://www.vtiger.com/</a><br>
</blockquote></div></div>
_______________________________________________<br>
<a href="http://www.vtiger.com/" rel="noreferrer" target="_blank">http://www.vtiger.com/</a></blockquote></div>
</blockquote></div>