How can I convert ate to day of week

Viewing 6 reply threads
  • Author
    Posts
  • August 19, 2017 at 8:36 PM #24073

    al m
    Participant

    Is there a way in calculated field to display to day-of-week of a particular date??’

    August 19, 2017 at 9:10 PM #24075

    Brendan
    Keymaster

    Yes. You can use the following function:

    DATE([Date Field], "EEEE")

    will give you “Tuesday”

    DATE([Date Field], "EEE")

    will give you “Tues”

    This website describes the various date patterns you can use with the DATE(X,Y) function:

    http://www.unicode.org/reports/tr35/tr35-31/tr35-dates.html#Date_Format_Patterns

    August 20, 2017 at 3:27 PM #24092

    al m
    Participant

    This does not work.

    August 21, 2017 at 7:51 PM #24122

    Brendan
    Keymaster

    Hmm… I did test it before I replied just to be sure.

    Which version of Tap Forms do you have?

    Also, if you’re using the Mac version [Date Field] just represents the name of your date field. Don’t put the square brackets in there on the Mac version. The iOS version requires them, but will be automatically added for you when you select a field to insert into your formula.

    August 22, 2017 at 8:33 AM #24130

    Mike Schwartz
    Participant

    al m:

    Make sure that the Result Type for your formula is set to “Text”.

    — Mike

    August 22, 2017 at 9:38 AM #24132

    Brendan
    Keymaster

    Oh yes, I forgot to mention the Text Result Type :)

    August 22, 2017 at 12:43 PM #24142

    al m
    Participant

    Yes correct it must be text. That works.

Viewing 6 reply threads

You must be logged in to reply to this topic.