02-08-2012 12:50 PM
Hi Experts,
I have to upload an excel file into program and update a Ztable. In the Excel file there is a column which is maintaining time in the format as follows:
d.hh:mm
317.22:15
i.e. 317 days 22 hours and 15 mins, if we add 3 hours to it then it will be 318.01:15.
I want a field to store this type of time format in the ztable.
So can u suggest me any data element which can solve my problem or any other solution.
Can I get a data element which can have hhhhhh:mm or hhhhhh:mm:ss format, so that i can store it using this format after calculating e.g. 317*24 = 7608; as 7608 + 22 = 7630; 007630:15 :: hhhhhh:mm.
02-08-2012 1:36 PM
Hi Abhi,
Your date time format does not contains year - check if You want to ignore it.
If You do not need year, than You can store it simply as INT4 type
and use conversion exit to change int to / from hhhhhh:mm:ss format.
Alternatively, You can convert it to date and time fields.
Regards,
--
Przemysław
02-09-2012 5:22 AM
Hi,
You can use the data element ANLVZ. or you can create your own data element with taking data type as TIMS which stores time as hhmmss.
Regards,
Ramesh.
02-09-2012 10:56 AM
Hi,
To be more specific, You can also use Data element TIMESTAMP which is in Form (YYYYMMDDhhmmss) It's a UTC (Universal coordinated time) timestamp.
Regards,
Mukul