Trying to build a field default value using data from a field in a different table. The deafult value contains multiple elements text ("ASFL"); then two-digit, fiscal year (12); then three digit julian date (123). I tried to use varying themes on the following to no avail:
= Display Text: IIf(Month(Now())>9,"ASFL" & Right(Year(Now()),2),"ASFL") & (Right(Year(Now()),2)+1))
I want to pull today's julian date from the tblJDate table; but, I also have to account for the government's fiscal year (why I tried to use an IIF statement).
Unfortunately, I keep getting an invalid syntax error.
Thanks in Advance for Your Help.
Tryin' to avoid newb behavior,
Paul.
= Display Text: IIf(Month(Now())>9,"ASFL" & Right(Year(Now()),2),"ASFL") & (Right(Year(Now()),2)+1))
I want to pull today's julian date from the tblJDate table; but, I also have to account for the government's fiscal year (why I tried to use an IIF statement).
Unfortunately, I keep getting an invalid syntax error.
Thanks in Advance for Your Help.
Tryin' to avoid newb behavior,
Paul.
Last edited:
