Prod: WF 5.3.4 @ Red Hat Enterprise Linux ES 3 (Taroon Update 6) w/Oracle 9i Test: WF 5.3.3 @ SUN Solaris 7 w/Oracle 8i
January 11, 2006, 11:34 AM
susannah
Ruben, what is it you want to fix? focus xlates a zero, and properly so, to the beginning of its date epoch, which is Dec 31, 1900. What does the date field in your oracle table actually contain? do an edit on it to an alpha version and print it out so you know your starting point? if your starting point is meant to be empty, can you define your source field as MISSING ON ?
In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
January 11, 2006, 03:09 PM
Vivian
You might want to look at the Set DateDisplay command. HTH
Vivian
Vivian Perlmutter Aviter, Inc.
WebFOCUS Keysheet Rel. 8.0.2 (Almost) 1001 Ways to Work with Dates thru Rel. 8.0.2 Focus since 1982 WebFOCUS since the beginning Vivian@aviter.com
January 17, 2006, 05:50 PM
rubenibi
sussannah you're always helping me!! with simply an EDIT the problem was solved, I can't reply before, I'm on holiday n_n
Vivian Thanks for your advice, I already tried with the DateDisplay option, but It didn't work, many thanks for hekping me ^^
Kerry Thanks you for you also, I didn't notice about the reply
____________________________________________ Ruben Rueda Consultant Information Builders Iberica