Controlling time field for an attribute

Hello Everyone,

We have a requirement to hide the time part of a date field for a custom object type and just capture the date when the document is created.I have hidden the time field, but its still registering the default time(12:00:00) in the database.Is there a way we can prevent this from happening ? I want the value to be null.

Thanks

Hari

Find more posts tagged with

BPM

Note:

If there are Accepted Answers, those will be shown by default. You can switch to 'All Replies' by selecting the tab below.

Accepted answers

aflowers001

There is no way that I'm aware of. I assume you are storing the value in a DM_TIME and under the hood this is a date AND time value in the database. You could possibly look to store the value as a string and read/write from that, but the question would be why? If you logic dictates that the time is ignored just make sure that this requirement is carried through to the UI and other methods of viewing the data.

All comments

aflowers001

haripsv

Hi Andy,

Thanks for the reply. I guess the simple answer would be say NO to the client .The problem they have is they have reports from another system which doesnt have these time fields and when they do a comparison it looks odd with 12:00:00 defaulted to all the entries.

Thanks

Hari

DCTM_Guru

"...when they do a comparison it looks odd with 12:00:00 defaulted to all the entries."

- Then they (or you) need to do the comparison correctly. If you are querying for documents based on specific date, use something like this:

r_creation_date>=date('9/19/2012 00:00:00) AND r_creation_date<date('9/20/2012 00:00:00)

aflowers001

they have reports from another system which doesnt have these time fields and when they do a comparison it looks odd

Is this comparing a report from the documentum metadata to another systems report? If so then just skip adding in the time to the documentum metadata report, some simple formatting should accomplish this

haripsv

The report is just an excel sheet which a set a users use it to enter metadata when the document gets created.I dont know where the report is coming from.From the documentum side, we dont generate a report. People access the application to check the dates. I guess I should have been clearer when I stated comparing reports.

Thanks

Hari

haripsv

Anyways thank you both for your input.Appreciate it.