Help me in trimming the date?

[durgabhavani]

Hi All,

Please find the my attached application and help me to trim the date.

here i have time stamp in my field but i want only date in the field and all the same dates need to combined and show the sum of values in the chart.

If i conveyed anything wrong, please let me know.

Thanks,

Durga

[Gysbert_Wassenaar]

Use the floor function to cut of the date part: date(floor(MyTimeStamp),'DD-MM-YYYY') as MyDate

[maxgro]

use function floor

in the chart, replace your dimension with a calculated dimension

=date(floor(DATE_GENERATED))

or

in the script

DATE:

LOAD

     date(floor(DATE_GENERATED)) as DATE_GENERATED

FROM

C:\Users\43899668\Desktop\Date.xls

(biff, embedded labels, table is Sheet1$);

[qlikmsg4u · Accepted solution]

PFA