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

Question

Question

Single line entry for date including time - dont want it to

Forms
Updated September 20, 2017
asked on September 20, 2017

Hello,

I have 2 single line entries that use the look up feature to populate the issue date and expiration date.

The dates come into the form with a generic time (12:00:00 AM).  The data source does not contain the time so it seems that forms is adding this somehow.

Can you help me make that go away?

Thanks in advance

 

0 0

Replies

replied on September 20, 2017

Another option is to create a hidden single line entry that accepts the full date time and apply a calculation (on the fields advanced tab ) to your displayed date that removes the time.

Calculation placed on the Date field:  =LEFT(hiddenDate, FIND(" ",hiddenDate))

3 0
replied on September 20, 2017

I limited the field to 10 characters in hopes that would do it.  It did not.

Thanks,

Christine

0 0
replied on September 20, 2017 • Show version history

Christine,

DateTime queries typically include a generic time value even if it is not used. What I would do is create a view or stored procedure in the database that translates the DateTime to a string that includes only the Date portion, then reference the View/SP instead of using the lookup on the table directly.

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

Sign in to reply to this post.

Details
Related Posts
Loading ...