Is there any formula function that can find the current date…not the day or month but just the year as 2005 for example!!!
Subject: Er…Formula: @Year(@Today); LS: Year(Today())
Subject: Finding the current year…!!
Mickey
@Year(@today)
look at @Now, @Today, @Month, @Day for other values/elements
Mike
Subject: RE: Finding the current year…!!
Im trying this code below where Start_Date is the current date as in 05/10/2005…all i want is for the current year to be the actual current year every time this form is accessed. Can i not do this???
currentYear:=@Year(Start_Date);
nDeductHols:=@If([06/06/currentYear]>= Start_Date & [06/06/2005]<= End_Date;1;0
This is the error i’m getting…thanks!!
Unable to interpret Time or Date: ‘[06/06/currentYear]’
I’m getting
Subject: RE: Finding the current year…!!
Your problem there is that [06/06/currentYear] is a literal expression. You can’t stuff a variable into it. You want something more like this:
@Date(currentYear; 6; 6)
Subject: RE: Finding the current year…!!
Cheers M Riggsby,
Thinking too much about it and overlooked that…working now, thank you!!
Subject: Finding the current year…!!
@Year(@Today)