Date Formatting

[#1]

How do I format a date field in a pivot table with making it an expression.

I have date as a dimension and it shows the time, I want the date only, I do not want the date as an expression b\c then it shows in the total section, which is not necessary

[its_anandrjs]

Do you have sample app for this or any sample data.

[its_anandrjs]

If you want the date only then use

Date(Date#(YourDateField,'DD/MM/YYYY'),'DD/MM/YYYY')

[ashfaq_haseeb]

Hi,

I suggest you to create two fields in you blackens one default date another with Date part only.

In your fronted use the date without time stamp.

you can remove time part as shown below.

Load *,

Date(floor(DATE_Field),'YYYY/MM/DD') as DatePart

from xyz;

Replace 'YYYY/MM/DD' with your date format.

Hope it helps

Regards

ASHFAQ

[jonathandienst]

Hi

It is usually better to do this in the load script. If you want date as a dimension, use the following calculated dimension (assumed date is the field name):

     Date(Floor(date))

HTH

Jonathan

[maxgro]

try

date(floor(field))

[vardhancse]

Hi,

In script level while loading the fields create one additional field only with date, and rename as required.

Date(Floor(Field)) as xyz_date,