date

[#1]

I want date as 1/04/2012 if I select year 2012 or any year ...

means I want only first date of april month for that particular year

can any one help??

[#2]

Try This

    if(year='max(year)',monthstart(monthname))

[Anonymous]

hi Reshma,

                  U can use MonthStart () function

                   Eg: MonthStart(Monthname)

                  Hope it workz....

regards,

Vaibhav

[#4]

but I want that particular year also get change what I select

[#5]

Can you share your test app with me

[#6]

if you use that above expression.......what output is it shows?

[#7]

Hi

use the makedate()

for exm

makedate(2012,4)---

it gives   4/1/2012

[#8]

Hi

see the below expr

i use this expr in calculated dimension

=makedate(year(PERIOD_START_DATE),month(today()))

it works for me

try this expr.

[#9 · Accepted solution]

I did this to ur expression and I am now getting the proper answer for that particular Year

=date(date#(if(Year=max(Year),'01/04/' & Year)),'MM,DD,YYYY')

[jagan]

Hi,

Try this, this is the simple way

=Date(MakeDate(Max(Year), 4, 1), 'DD/MM/YYYY')

Regards,

Jagan.