marks
|
| Posted: 02/28/2003, 2:34 PM |
|
I am using CCS to present reports from an existing database, the date format written to the database is julian. How do I get a value such as 1046443045 to show up as February 28, 2003 2:38? (or whatever minutes and seconds that example number works out to)
|
|
|
|
marks
|
| Posted: 02/28/2003, 3:10 PM |
|
Figured it out.
In the before show event for the date label, use DateAdd.
Eg. mydate.value=DateAdd("interval",mydate.value,"1-Jan-70 12:00:00")
Its amazing what you can do when you put your thinking cap on 
Thanks to all who considered answering this, TIA!
|
|
|
|
|
|
