Source language: Translate to:

About field w/ time value

Questions about our Advanced Database plug-in

Moderator: Neosoft Support

About field w/ time value

Postby carlos torres » Wed Sep 17, 2008 6:40 pm

Hi

I have to keep the time value in a field it works ok into the database BUT when I display that field in NB it appears as

Code: Select all
30/12/1899 08:23:14 p.m.


I just need to show time value. How can I avoid this behavior?

I'll appreciate your help

regards,

carlost
User avatar
carlos torres
 
Posts: 289
Joined: Mon May 02, 2005 8:14 am
Location: Pamplona, Colombia

Postby Gaev » Wed Sep 17, 2008 7:05 pm

Carlos:
I just need to show time value
use ...
Code: Select all
dbpSetFieldProperties "database id" "table" "field" "properties"

The Help file section for dbpSetFieldProperties describes use of "properties" ... one of the choices is ...
Code: Select all
DisplayFormat=value
This option can be used to specify the display format used for date/time and numeric field types. The display format affects the appearance of the field values in both the grid and NeoBook field variables. See Formatting Fields for more information.
... and the link from Formatting Fields takes you to the page which describes all the available values ... you probably need ...
Code: Select all
DisplayFormat=hh:nn:ss ampm
or
DisplayFormat=h:nn:ss ampm
User avatar
Gaev
 
Posts: 3716
Joined: Fri Apr 01, 2005 7:48 am
Location: Toronto, Canada

Thanks

Postby carlos torres » Thu Sep 18, 2008 6:31 am

Thank you Gaev

I use that command before for numbers, but it will be nice that that command shows some masks for common display formats. I figure out that it will be a good suggestion for the next dbp plugin.

As many times (always) you're Right!

regards

carlost
User avatar
carlos torres
 
Posts: 289
Joined: Mon May 02, 2005 8:14 am
Location: Pamplona, Colombia


Return to NeoBookDBPro

Who is online

Users browsing this forum: No registered users and 1 guest