How to change date format inside a text field?

[johnrohan]

Here is my issue. I have a text field in my table called "fiscal year", which, not surprisingly, is the fiscal year (in the US starts on Oct 1st).



So I calculate it with this expression as the default value:

=IIf(Month(Date())<10,Year(Date()),Year(Date())+1)


This works fine, except it displays the year as "2017". Is there any way to get the year to display as "17" only?

If I put yy in the format value, nothing happens. I guess that only works in date/time fields. But if I change this to a date/time field, then it won't understand the expression I use to calculate the fiscal year. I've tried using the format command inside that expression, with no success, and not sure if that is possible anyway.

Does anyone have any ideas on a way to format this or a work around?

[CJ_London]

try

=right(IIf(Month(Date())<10,Year(Date()),Year(Date ())+1),2)

[RuralGuy]

Have you tried Mid(YourString,2)
I might have that syntax wrong.

[johnrohan]

try

=right(IIf(Month(Date())<10,Year(Date()),Year(Date ())+1),2)

Thank you! simple solution and it works. It doesn't work on previous entries, but it applies it to all new ones. I can work with that.