Submitted by Jon on 2009/06/05 09:12
Hi:
 
Most programs maintain separate time and date fields. Let me use UR as an example. I can export the data in csv format and import into separate time and date fields within IQ. The problem arises when I want to display my appointments using a gantt chart (so I can see the flow of thhe day and conflicts at a glance) or the calendar. How can I accompliish what I want?
 
(I know that Pierre is developing import capabilities from UR, but how will these separate fields be intelligently managed? There are times when keeping them distinct is required.) 
 
Jon

Comments

Jon

2009/06/05 13:53

Permalink

[quote=Pierre_Admin]
The separation is an UI thing. Internally apps store date and time in a single field.
[/quote] 
 
Then there is something I don't understand. UR has discreet fields for the date and time. You can examine them in SQLite. Additionallly, they are exported as separate fields in a csv file. So how would I create a field that IQ could use for imported appointment data?
 
Unless I am missing something...
 
Jon

Pierre_Admin

2009/06/05 13:58

Permalink

If there are discreet in the csv file, then you can create a date and a time field (both of type Date) and import into these. Then I can help you combine these into a single IQ field

Jon

2009/06/05 16:31

Permalink

Yes, this is exactly what I have done.
 
Jon 

Pierre_Admin

2009/06/05 16:51

Permalink

OK, To combine the two, you set the equation of a date field to:
=cdate([DateField])+cdate([TimeField])
 
And click the update button (just next of the equation box).
 
Once you've verified that everything is OK, you can delete the date and time fields, and remove the equation