Minimum Date calculation

[AH]

Hi,

I have couple of dates for a single customer. So I want to calculate the first date as Account start date. I was trying to use this in the script but its showing invalid expression.

Min((Date#(InstallDt,'YYYYMMDD')) as [Account Start Date])

Am I doing wrong somewhere?

Thanks,

Shan

[rubenmarin]

Hi, try removing 1 '(' after Min():

Min(Date#(InstallDt,'YYYYMMDD')) as [Account Start Date])

[anbu1984]

Also remove last ')'

Min(Date#(InstallDt,'YYYYMMDD')) as [Account Start Date]

[AH]

Still Showing Invalid Expression.

Thanks,

Shan

[rubenmarin]

Hi Shan,

For [Account Start Date]  you are using Min, to do this you need to have a Group By clause?

In case you have the Group By clause yo need to add all non-aggregated fields to the group by, or use funcions like MinString(), Min(), Sum() to convert non-aggregated fields into aggregated fields.

Hope this helps

[#6]

Hi,

Try this

Min(Date(InstallDt,'YYYYMMDD')) as [Account Start Date]

or Min(Date#(InstallDt,'YYYYMMDD')) as [Account Start Date]

[AH]

The expression is not working.

[AH]

Ruben,

No I am not using any Goup By Clause.

Thanks,

Shan

[sasikanth]

hi

try some thing like

date#(min(Installdt),'YYYYMMDD') as [Account start date]

[AH]

Actually i am using this Minimum Date (Account Start date) in the Chart. Is there any way i can change the dimension and make the expression there to get the Minimum date?

Thanks,

Shan