Cloning an Alpha or Number Field as a Date/Time

The following script causes the define command to map a DMSII ALPHA or NUMBER date/time item as a relational database date/time item.

File name: script.user_layout.payment

update DMS_ITEMS set di_options=128, dms_subtype=121
where dms_item_name='PAY_REC_TIME' and dataset_name = 'BUFFALO-CHIPS'