0

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

5replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Hi,

    either

    format('date field',"dddd")

    or

    weekdayName(weekday('date field'))

     

    Leo

    Like
    • Katie Rayner
    • Be Legal Property Compliance
    • Katie_Rayner
    • 2 yrs ago
    • Reported - view

    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)

    Like
  • either

    format(today(),"dddd")

    or

    weekdayName(weekday(today()))

     

    Leo

    Like
    • Katie Rayner
    • Be Legal Property Compliance
    • Katie_Rayner
    • 2 yrs ago
    • Reported - view

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

     

    Saved me a call to Birger :)

    Like
    • Katie Rayner
    • Be Legal Property Compliance
    • Katie_Rayner
    • 2 yrs ago
    • Reported - view

    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 :)

    Like
Like Follow
  • 2 yrs agoLast active
  • 5Replies
  • 1582Views