Why does Hyperion's Trunc(date) return large number?

Question

I am working with Hyperion and I have never used it before about two weeks ago. Someone else set up a .bqy file to get certain columns from a DB. He has one column with this formula in it: Trunc(date) where date included the date and time.

What that column shows, though, is not the date. It shows large numbers like this: 1,377,826,863,000. They all end in 000.

What are those numbers?

Answer 1

Probably milli-seconds since the Epoch of 1/1/1970 with a resolution of 1 second, hence the 3 zeroes at the end. See Wikipedia article for "Unix Time" here.

You can convert to a string, using one of the methods here.