I've done this before, but I can't find my examples. Can someone tell me how to display the short month (Dec, Jan, etc.) by extracting it from another (Date)field in a query?
I've done this before, but I can't find my examples. Can someone tell me how to display the short month (Dec, Jan, etc.) by extracting it from another (Date)field in a query?
One way:
Format([DateField],"mmm")