Having just finished Expert28 Lesson6 I noticed an error in the CodeSampleF for the Ordinal IIF Function. The function in the form is: Suffix: IIf([D]=1 Or [D]=21 Or [D]=31,"st",IIf([D]=2 Or [d]=22,"nd",IIf([d]=3 Or [d]=33,"rd","th")))
I believe it should read: Suffix: IIf([D]=1 Or [D]=21 Or [D]=31,"st",IIf([D]=2 Or [d]=22,"nd",IIf([d]=3 Or [d]=23,"rd","th"))) Thank you
Adam Schwanz
@Reply 4 years ago
Correct, unless you have a special calendar that goes to the 33rd of each month ;).
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Expert 28.
