Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I always use date(floor(field))
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
There are various way, usually we use FLOOR-function for this purpose:
FLOOR(Timestamp)
HTH
Peter
I always use date(floor(field))
Thanks for all the useful suggestions.
I have used date(floor(date)) and it works fine!
Cheers
Sandy