Convert to Date/Time

[system]

Using report how can I convert a character string like “6.7.04 10:12:15” (the 7 being the month) into a usable date format preferably like dd/mm/yyyy HH:mm:ss.

All the dates appear to be stored in some norwegian format, as a charater (I think).

Once converted (if possible), I also need to then know the best way to take one date away from the other to get the hours/mins/secs between. eg. (01/12/2004 12:00:00) - (30/11/2004 12:00:00) = 24:00:00

Many Thanks

---

octoped (BOB member since 2005-02-05)

[system]

You should try creating a variable based on your date character string. Use the ToDate function.

After the variable is created, you can format the data cells as Date/Time.

---

Paul Carletta (BOB member since 2003-12-18)

[system]

As Paul pointed out use the Business Objects Reporter function ToDate and look at this thread.

By the way welcome to BOB

---

Andreas (BOB member since 2002-06-20)