Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
Now my year field as below :-
year([date]) as [year],
it generate 2009 2010 2011 2012
How to make it display as 09 10 11 12 ?
Now i am using below script at list box, which is not a good approach :-
=
IF(year='2014','14',
IF(year='2013','13',
IF(year= '1997' ,'97',
IF(year= '1998' ,'98',
IF(year= '1999' ,'99',
IF(year= '2000' ,'00',
IF(year= '2001' ,'01',
IF(year= '2002' ,'02',
IF(year= '2003' ,'03',
IF(year= '2004' ,'04',
IF(year= '2005' ,'05',
IF(year= '2006' ,'06',
IF(year= '2007' ,'07',
IF(year= '2008' ,'08',
IF(year= '2009' ,'09',
IF(year= '2011' ,'11',
IF(year= '2012' ,'12',
IF(year= '2010','10'))))))))))))))))))
Paul
Right(Year, 2)
Hi Paul,
Simple use
=right(Year,2)
Hi Sir
Thank you for reply , my org code :-
year([date]) | as [year], |
I try to replace with below cannot work :-
right(year,2([date])) | as [year_], |
Any advise ?
Hi Sir
work now. Thank
Right(year(date),2) | as [year_], |
Hi Paul,
To Remain the format of Year as Year, you can use the Date() function, see below:
Date(DateTrans, 'YY') as Year_in_Two_Digits
Also, see attached file for your reference! Thank you.
Regards,
Bill
Hi Bill
Now i face another issue which is not able to sort from 96 99 10 in sequences.
See my new post :-
Did you apply the one I suggested? If yes, I guess, you can now sort it respectively Paul.
Hi Paul
PFA Hope it is helpful
Hi Mr. Paul,
I know that you found solution on this. But I would recommend you to use function below:
Date(YearStart([DateField]),'YY')
Regards,
Sokkorn