Formula for date begin selected year

[#1]

     Hi,

I'm looking for the formula in the expressions for the first day of the selected year.

So if I select 2014 i wanne have 01-01-2014

If I select 2013 i wanne have 01-01-2013.

Can somebody help me?

[Anonymous]

Try the YearStart function

[#3]

I have this formula at the moment: date(YearStart( Today()))

But that one gives me 01-01-2014 while I selected 2013

[ashfaq_haseeb]

Hi,

Try below

=YearStart(Your Date)

Regards

ASHFAQ

[ashfaq_haseeb]

Hi,

Replace today() with your datefield.

Regards

ASHFAQ

[Anonymous]

Today() returns today's date.

You need to use whatever field you are doing the selection on.

[#7]

Thank you very much for your help. Doesn't work yet but I understand why it doesn't work. Trying to get the right date field instead of Today().