Question

Date column invalid format error: The data assigned to field 'Student DOB' is not valid. 9017

Workflow Laserfiche Forms How To

Updated two days ago

asked on September 12 • Show version history

I am using regular expression to extract date from file name:
File name: Lastname, FirstName_PERMIT_Type_20090112
RegEx: (\d{8})$
Date field format: Short date

And getting this error:
Set Student Field Values. The data assigned to field 'Student DOB' is not valid. 9017 [Bad field value. [9017]] [0265-WF10]
Can someone help please to resolve this issue. Workflow is running but date field is not getting populated with the result i am getting from regex

0 0

Replies

replied on September 12

Hi Kartik,

The date field will be expecting the format MM/DD/YYYY or DD/MM/YYYY depending on which format you're using.

If you try copying and pasting 20090112 into a date field manually you'll quick see the issue.

It was discussed here and a solution using Quick Fields https://answers.laserfiche.com/questions/213124/Convert-String-Date-yyyymmdd-to-format-mmddyy-using-Regex

You'll likely have to use a Token Calculator and substitute activity to re-format the date.

Another option would be to change the date format of the date field itself using a custom format, which is explained here https://doc.laserfiche.com/laserfiche/en-us/Content/Field_Display_Formats.htm#CustomDateandTimeFieldDisplay

Hope this helps!

Chris

3 0

replied on September 12

Apologies beginner here, didnt get it completely.
I am getting date as 20090112 how can convert it into the format which Laserfiche short date column requires?
I can add another assign token values action below it and add another token in it but what to do after that ?
Apply function dosent have convert option

0 0

replied two days ago

Hey Kartik,

To keep it simple, I'd simply break out the bits you need in separate pattern matches like so:-

Year

Month

Day

Then use the assign token activity and create a new document date token to use in the field activity later on to bind them all together in the format you need. DD/MM/YYY or MM/DD/YYYY whatever the date field is configured to.

If you're still struggling after trying this I'd suggest you reach out to your solution provider for some additional assistance.

Good luck!

1 0

You are not allowed to follow up in this post.

Question

Question

Date column invalid format error: The data assigned to field 'Student DOB' is not valid. 9017

Replies

Sign in to reply to this post.