Converting a timestamp into a date dimension.

[#1]

Hi,

I am loading data via a qvd file and have a date field called date which is a timestamp field.

I want a listbox that contains only a single date for each day.

How can I use daystart() or or similar to convert these already loaded date timestamp values into a new field for my date only listbox?

Many Thanks

Sandy

[rbecher]

Hi Sandy,

a good way is to load a separate date field from the timestamp with function date#(<timestamp>,<date format>) in the same load statement.

Then you can add a date listbox on this field which will display all dates once...

- Ralf

[prieper]

There are various way, usually we use FLOOR-function for this purpose:

FLOOR(Timestamp)

HTH
Peter

[Anonymous · Accepted solution]

I always use date(floor(field))

[#5]

Thanks for all the useful suggestions.

I have used date(floor(date)) and it works fine!

Cheers

Sandy