How do I express a date to a day, like Monday or Tuesday. Other than using a choice box with a dropdown list. Thank you
Thank you for considering my question
I have this question also, but I would like the day to be 'today'. So far if I select that it will come up with '29' (for today 29th Jan). I want it to instead say 'Wednesday' (for today 29th Jan)
format(today(),"dddd") - worked perfectly thank you!!
Saved me a call to Birger :)
I am trying to create a field for one of my printed reports that has the 'next inspection date' displayed for the customer.
However, I need this field (appointment format) to be split into two boxes/fields - one displays the 'next inspection date' date only and the second box displays the 'next inspection date' time only.
I've tried a few different things, thought I may be able to solve it based on something similar to your coding above, however I'm not sure if the appointment format is able to be split up.