Time not updating in PJREVHDR table

(0) Share

Report

Posted on by Jo Wykerd

1,615

Hi there,

I have a customisation whereby i have added another field (PJREVHDR.USER7) to the screen Budget Revision Maintenance (BUBRM). I populate this field with the current date and time - NOW() - which seems to work correctly when i check in VBA using debug. The problem is that when the revision is saved and i check in the table in the DB, only the date part of the field is saved - the time part is 00:00:00. For some reason the time part is not being carried over and saved. Can anybody help? PS. another option would be to populate User7 with the same value as field crtd_datetime when saving. Not sure how to do that though?