How do Extract a Day from a Date?

Tap Forms Database Pro for Mac, iPhone, iPad and Apple Watch › Forums › Using Tap Forms 5 › How do Extract a Day from a Date?

Viewing 2 reply threads
  • Author
    Posts
  • April 14, 2018 at 10:51 AM #28260

    Alan Hutchison
    Participant

    In my client database I have a “Date Started” Date Field.

    I would like to create a “Due Date” field which is the Day value within the date field so I can then get an easy view of payments coming in that month.

    Anyone ideas?

    April 14, 2018 at 11:07 AM #28262

    Alan Hutchison
    Participant

    Ah – I figured it out.

    STR2NUM(RIGHT(DATE([FIELD-NAME]; “yy-MM-dd”),2))

    April 14, 2018 at 6:37 PM #28268

    Brendan
    Keymaster

    You could also probably just set the date pattern to “dd” instead of having to do the RIGHT() function to pull out the last 2 digits.

  • Author
    Posts
Viewing 2 reply threads

You must be logged in to reply to this topic.