Skip to Content
0
Dec 16, 2013 at 05:38 AM

ERROR in Formatdate function

28 Views

Hi,

i have find out lastyear and current finanicial customer count

for that i have take year separtely,i have applied following formula for fomatdate error is giving..

=FormatDate([Visit].[L01 Cal. year / month]();"yyyy")


[Visit].[L01 Cal. year / month] having values following format


04.2012

05.2012

06.2012

.

.

04.2013

05.2013

.

.

11.2012


i have to take Customer Count of 2012 separately,2013 separately..

i need customer count of 2012 and 2013 separately,

plz help,,find the error screen shot..



Attachments

error14122013.JPG (84.9 kB)