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

Question

Question

Date starting with 0 in Quick Fields

asked on February 24, 2014

Hi,

 

Is there a way to have a date field start with zero in Quick Fields? I've altered the date field format within the client to include the zero in the month e.g. 02/24/2014, but I cannot seem to enforce this in Quick Fields. It automatically removes the zero, and creates a space between the 2 and the / to look like 2 /24/2014. 

 

Thanks,

 

Brian  

0 0

Answer

SELECTED ANSWER
replied on February 24, 2014

Quick Fields allows you to put constraints on fields (even if such constraints do not exist in the client) which can enforce date formatting. 

If you are using a token for the date you can also put formatting on it to force it into a specific date format:

 

 

0 0
replied on February 24, 2014

Thanks, Matt. That is excellent, and exactly what I needed. 

0 0
replied on February 24, 2014

You're welcome, glad I could help.

0 0

Replies

replied on February 24, 2014 Show version history

Are you wanting it displayed for users using quick fields interactively this way? Or do you only care when it's inside laserfiche?

 

There's two issues here. One is the space issue. To tackle that I usually use a regular expression of when I'm capturing by setting a token with the following: (\d\d?)/s?(\/)\s?(\d\d?)/s?(\/)\s?(\d\d\d?\d?) then applying that token to the date. This way it doesn't return leading or tailing spaces around the / symbol and it will accept a 1 or 2 digit date for month and day along with a 2-4 digit year. 

 

I actually also try to avoid actually filling out the date inside quick fields unless my data source is very clean, and instead let workflow try to set it based on a passed string token using date token caculator. (this is more important if using QF Agent)

 

 

EDIT: Matt Ross covered this part that I didn't know much better. 

For the leading 0 when it doesn't see it, I don't know of a way offhand to change that in quick fields. However internally inside laserfiche I don't think it includes a leading 0 either, it just displays or exports based on your field display format

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

Sign in to reply to this post.