Time as a Dimension

[tmumaw]

Hi all,

I am trying to use the following as a dimension with no luck.  What am I missing? 

Thanks

time(date(Opportunity.CreatedOn,'YYYY/MM/DD hh:mm:Ss'),'hh TT') as Hour_Created

Example:

12 PM  and then counting the number of opportunities created at 12 PM.

[its_anandrjs]

The expression seems ok if you try with

Eg:-

=Time(Date(now(),'YYYY/MM/DD hh:mm:ss'),'hh TT') //Same as your expression

[tmumaw]

The expression works perfect, but when I use Hour_Created as a dimension I get the following:

12 PM 1

12 PM 1

12 PM 1

Where is should be 12 PM 3

[Clever_Anjos]

You must get only time fraction

time(frac(Opportunity.CreatedOn),'hh TT') as Hour_Created

or

time(round(frac(Opportunity.CreatedOn),1/24),'hh TT') as Hour_Created if your field holds minutes too

[its_anandrjs]

Plot list box of Opportunity.CreatedOn and in expression write code

Len( time(date(Opportunity.CreatedOn,'YYYY/MM/DD hh:mm:Ss'),'hh TT') )

Check it is 5 or 7 if it is 5 then ok but 7 need to check your load script.

[#6]

hi

try this

date(date#(Opportunity.CreatedOn,'YYYY/MM/DD hh:mm:ss'),'hh TT')

[tmumaw]

It's 5

[tmumaw]

Nothing in Hour_Created.....

[its_anandrjs]

Try one of this

=Time(Timestamp(Opportunity.CreatedOn,'YYYY/MM/DD hh:mm:ss'),'hh TT') as Hour_Created

Or

=Time(Date(Opportunity.CreatedOn,'YYYY/MM/DD hh:mm:ss'),'hh TT')

Or

=Date(Date#(Opportunity.CreatedOn,'YYYY/MM/DD hh:mm:ss'),'hh TT')

[#10]

OK, PLEASE TRY ACCORDING TO THIS

=date(date#(

now()

,'MM/DD/YYYY hh:mm:ss TT'),'hh TT')