Greetings wise ones!
I have a base to track family medical history which includes a Doctors table and a Dr Appointment table. All appointments in the Dr Appointment table are linked to a doctor in the Doctors table. This includes past appointments an...
Is there a formula where I can convert a date in a date field to a string of numbers? For example, for today (2020-11-20) I would like it to return “201120”
Thank you @Vivid-Squid ! That wasn’t quite it, but you put me on to the idea of conditional Rollups (which I’d read about but hadn’t used yet).
and
gave this (exactly what I wanted)
Absolutely! Did not mean to overlook your quick help @Jeremy_Oglesby :slightly_smiling_face:
I am very impressed with the know-how and generosity of this community. It makes learning more fun!
Thanks Kuovonne :slightly_smiling_face: I really admire how you taught yourself so much and so well! You’ve been very inspiring in the videos I’ve seen. That project with the book about plants? Amazing.
OK, Kelly, breathe, breathe… Try not to freak out that Kuovonne, of the September virtual conference and other videos fame, just answered your question!!!
Hey Kuovonne, thanks! Yes, I just want to use the date as the invoice number, but appreciate yo...