InfoQube IM - Community

Submitted by jan_rifkinson on 2009/10/22 09:19

I have an automated date field, i.e. every time i add an item, a date is created & displayed.

However the display is mm/dd/yyyy hh:mm:ss

I want to limit to mm/dd/yyyy

What property do i adjust & what do I enter to control this format?

Thank you.

Comments

Do you want to store the time or not?

If no, you want to set the field default to:
- =int(now())
if yes, but don't want it displayed, there are a couple ways. See -- link to nonexistent node ID 404 -- and Smart Fields

HTH

[quote=Pierre_Admin]

Do you want to store the time or not?

If no, you want to set the field default to:
- =int(now())
if yes, but don't want it displayed, there are a couple ways. See -- link to nonexistent node ID 404 -- and Smart Fields

HTH

[/quote]

Pierre - can you clarify what you mean by 'store the time' ?

EDIT/ Also:

what the difference to adding =int(now()) to Field Management Dialog > General > Default Value

and adding to options:

Hide the time part of a date: <format>Short Date</format> (from -- link to nonexistent node ID 404 --)

EDIT #2/

I think this is it:

the =int(now()) just records the date in the field
the other methods (using 'options') record the time as well but they stop it from being shown in the field column

???

>Pierre - can you clarify what you mean by 'store the time' ?

Litterally : do you want IQ to record the time (hh:mm:ss) of the event, yes or no ?

=================

I don't know but none of these date "tricks" work (well, they work, but only if I manually enter the date)... I must be doing something wrong.

I tried the <format>Short Date</format> in options, together with =int(now()) (or int(now)) but I always end up with dates ending with oo:oo:oo when they're calculated using functions.

here's an example of one my functions (.. I know, not great) :

Function DueDate_EQ_TaskActEnd( duedate,TaskActEnd )    '
if isnull(DueDate) then
    DueDate_EQ_TaskActEnd = TaskActEnd
elseif isnull(TaskActEnd) then
    DueDate_EQ_TaskActEnd = duedate
else
    DueDate_EQ_TaskActEnd = duedate
end if
end function

I tried (but doesn't work at all) :

Function DueDate_EQ_TaskActEnd( duedate,TaskActEnd )    '
if isnull(DueDate) then
    DueDate_EQ_TaskActEnd = int(TaskActEnd)
elseif isnull(TaskActEnd) then
    DueDate_EQ_TaskActEnd = int(duedate)
else
DueDate_EQ_TaskActEnd = int(duedate)
end if
end function

Armando, Stupid question: did you try closing / re-opening program? That's what did it for me.

Jan Rifkinson

Ridgefield CT USA

HP Blackbird Vista Ultimate SP-2

Jan : THANK YOU !

Yes, maybe a "stupid" question, but it worked. I can't believe how much time I lost on this one.

IQ has to give indications to user about these things if it's not going to apply change instantly.

Armando, glad it worked for you.

This kind of inconsistency is the kind of thing that makes me go absolutely NUTZ when working w IQ (which I do every day).

As you say, at the very least, IQ MUST have the courtesy to inform users what to expect.

I don't know what you do for a living (info not important) but I'm retired so I sometimes have time to waste & play around but if I were in a work environment, I would find this kind of thing absolutely unacceptable.

If Pierre envisions IQ as a program that is customized & set up for various firms where there is limited input from employees, that's one thing but if he envisions IQ in a broader market, I think he must make some moves to make IQ more intuitive, consistent & informative (error msgs, warnings, instructions).

Even much of the manual -- with all the work that has gone into it by Keith, Tom, you & others -- is still a mystery to me because it doesn't take users thru a process step by step. It assumes too much & will ignore simple things like Main Menu > Tools > Options before getting down to the option (this is probably an exaggeration but I hope my message is clear)

And if Pierre & others read this I hope everyone is clear about one thing: this is a great program, Pierre is extremely supportive, I love this program, I want it to succeed..... in my lifetime.

Jan Rifkinson

Ridgefield CT USA

HP Blackbird Vista Ultimate SP-2