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
D

Thank you for considering my question

Ninox Profile

Hi,

either

format('date field',"dddd")

or

weekdayName(weekday('date field'))

 

Leo

K

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)

Ninox Profile

either

format(today(),"dddd")

or

weekdayName(weekday(today()))

 

Leo

K

format(today(),"dddd") - worked perfectly thank you!!

 

Saved me a call to Birger :)

K

Hi Leo,

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.

Thanks :)

Reply