I have a text formula that links to a date field with the "Yes, add options like repeat and end-time to use with a calendar." enabled. So each date field contains a From / To date
When using the text formula to link to that field, by default it displays e.g. 17/06/2018 - 20/06/2018.
Is there a way to display 1stDD - 2ndDD MMM so that the output gives 17 - 20 JUN?
I tried achieving this with formatDate, but using that function allows you to change the display of the From value only. Or I am missing something?
PS: I know that a way around it is to create two separate date fields, one for From and one for To, but the entry process when using the "Yes, add options like repeat and end-time to use with a calendar." option is smoother and more importantly, the calendar view allows the record to be displayed as a block of those dates instead of just the From or To date if I separate them into two fields.