Date on year selection

[#1]

Hello,

When Year is selected then, I want 1st date of April month in a text object.

eg.

2012 -> 01/04/2012

2011 -> 01/04/2011

Please reply.

Thanks

[Anonymous · Accepted solution]

=if(Year>0, '01/04/' & Year)

If you only want a text object with the value, you can use the above expression.

[#3]

Hai,

Please find the attachment ,May be this is what you need.

Thanks,

Rathish

[jagan]

Hi,

Try this

=MakeDate(Max(Year), 4, 1)

Hope this helps you.

Regards,

Jagan.

[#5]

Hi

use the makedate()

makedate(year(today()),month(today()))

[#6]

Thanks

[#7]

Thank You Guys..........:)