Format for date fields in pdm_load files
search cancel

Format for date fields in pdm_load files

book

Article ID: 35467

calendar_today

Updated On:

Products

CA Service Management - Service Desk Manager CA Service Desk Manager

Issue/Introduction

I am manually creating input files for use with the Service Desk utilities, pdm_load and pdm_userload. What format should I use for date fields in my files?

Environment

Release: SDMU0M99000-14.1-Service Desk Manager-Full License
Component:

Resolution

The Input format for dates for pdm_load/pdm_userload input files is "MM/DD/YYYY HH:MM:SS" 

e.g:

TABLE Call_Req

        id ref_num open_date

        { "400001" ,"22" ,"04/21/2015 11:28:40" }