Jump to content

How to convert a Date_Time field to a Date only field


Michael Delgado

Recommended Posts

  • IPRO Employee

The following workflow can be used to take the Date value from a Date_Time field and transfer only the Date value into a second field.

 

1. Use Eclipse SE Administration create new fields for all DATE_TIME fields you wish to convert. Make sure to set the Field Types = "Date".

2. In Administration under Client/Caser Management select Global Search and Replace.

3. Select the correct Client ID and Case

4. Next select the documents to be updated by choosing one of the following options: "Entire Case", "Image Key Range", "Advanced Search", or "Saved Search".

5. Select the Option "Replace Field" and "Copy"

6. In the From Field selection list select the DATE_TIME field (field to copy from).

7. In the To Field selection list select the DATE field (field to copy too).

8. Click Start

 

The utility will copy the data from the DATE_TIME field into the DATE field excluding the time value.

 

Link to comment
Share on other sites

  • IPRO Employee

The following workflow can be used to take the Date value from a Date_Time field and transfer only the Date value into a second field.

 

1. Use Eclipse SE Administration create new fields for all DATE_TIME fields you wish to convert. Make sure to set the Field Types = "Date".

2. In Administration under Client/Caser Management select Global Search and Replace.

3. Select the correct Client ID and Case

4. Next select the documents to be updated by choosing one of the following options: "Entire Case", "Image Key Range", "Advanced Search", or "Saved Search".

5. Select the Option "Replace Field" and "Copy"

6. In the From Field selection list select the DATE_TIME field (field to copy from).

7. In the To Field selection list select the DATE field (field to copy too).

8. Click Start

 

The utility will copy the data from the DATE_TIME field into the DATE field excluding the time value.

 

Link to comment
Share on other sites

  • IPRO Employee

The following workflow can be used to take the Date value from a Date_Time field and transfer only the Date value into a second field.

 

1. Use Eclipse SE Administration create new fields for all DATE_TIME fields you wish to convert. Make sure to set the Field Types = "Date".

2. In Administration under Client/Caser Management select Global Search and Replace.

3. Select the correct Client ID and Case

4. Next select the documents to be updated by choosing one of the following options: "Entire Case", "Image Key Range", "Advanced Search", or "Saved Search".

5. Select the Option "Replace Field" and "Copy"

6. In the From Field selection list select the DATE_TIME field (field to copy from).

7. In the To Field selection list select the DATE field (field to copy too).

8. Click Start

 

The utility will copy the data from the DATE_TIME field into the DATE field excluding the time value.

 

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...