min date_created not showing correctly

[suvechha_b]

Hi All ,

Please kindly assist  ,

How can I get the min date_created in the below dimension . I don't want the timestamp of the date_created .

Currently I used this -

=Aggr(Min(TOTAL <batch_ref> (date_created) ), batch_ref, (date_created) )

But it showing me with timestamp.

Even if I used -

=Date (Aggr(Min(TOTAL <batch_ref> (date_created) ), batch_ref, (date_created) ) )

it is not showing the timestamp but coming in two different line .

My requirement is -

Application Date should reflect 2018-07-14 in one line

Thanks,

[sibin_jacob]

Hi Bhadra,

Please use the floor function before to Date function

Date (

Floor(

Aggr(Min(TOTAL <batch_ref> (date_created) ), batch_ref, (date_created) )

))