Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Do you have sample app for this or any sample data.
If you want the date only then use
Date(Date#(YourDateField,'DD/MM/YYYY'),'DD/MM/YYYY')
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
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
try
date(floor(field))
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,