You are viewing limited content. For full access, please sign in.

Question

Question

Change field type

asked on January 10, 2018 Show version history

I am working on a project that contains fields of type date but that are in text type format ... Is there a problem in just changing the format to date type?

And if so, what will be the best way to make the format change without losing the values in laserfiche?

0 0

Answer

SELECTED ANSWER
replied on January 10, 2018

I suggest the following:

  1. Add the new field (type=date) to the documents' template
  2. Create a workflow to copy the old field (type=text) to the new one (type=date). You should use regular expression and Date token calculator in order to transform a string into a date.
  3. Delete the old field from the documents' template

Attached you can find a useful workflow (just change the file extension from ".txt" to ".wfx")

Good luck!

Text to Date.txt (11.79 KB)
2 0
replied on January 11, 2018

Thanks for the help Henry, it has been of great benefit to me

1 0
replied on January 12, 2018

Glad to hear that.

0 0

Replies

You are not allowed to reply in this post.
You are not allowed to follow up in this post.

Sign in to reply to this post.