How to get Distinct Year

[NavinReddy]

Hello Everyone,

With below expression im not getting distinct year, how to avoid duplicate years while loading script

Any suggestion or modifications on below expression

=Date(Mid([MTRC_FCT_DT],1,8),'YYYY') as Year

Best Regards,

Niranjan

[Chanty4u]

load *

Distinct([MTRC_FCT_DT]) as  newyear

[jagan · Accepted solution]

Hi,

If you are getting year from Date field

=Year(YearStart(Date(Mid([MTRC_FCT_DT],1,8)))) as Year

Regards,

jagan.

[avinashelite]

Try like this :

makedate(Mid([MTRC_FCT_DT],1,8)) as Year

[senpradip007]

Share your qvw, it would easy for us to help.

[Anonymous]

=Year(Yearstart(Year),1,4) as Year try this one

[Digvijay_Singh]

Use Year function to extract Year from Date.

[tyagishaila]

May be,

need group by

Share your .qvw to resolve it

[Anonymous]

What it is contain [MTRC_FCT_DT]??

Is this field contains Date only??

[Anonymous]

In list box to taken the distint values only