Discussions

Expand all | Collapse all

Field that is the same day every month

  • 1.  Field that is the same day every month

    Posted 18 days ago
    Hi Everyone,

    I'm sure there is a simple answer to this, but instead of continuing to beat my head against the wall, I figured I'd ask those with more experience.

    I'm trying to figure out how to create a date field that is always the same day of the current month. Here's what I tried:

    Date(Year(Today()),Month(Today()),Day("25")) 

    I did this both with and without the quotes, and it wasn't happy either way.

    Is there an easy way of doing this?

    Thanks for your help.

    Tammy


    ------------------------------
    Tammy Churchill
    ------------------------------


  • 2.  RE: Field that is the same day every month

    Posted 18 days ago
    you were close

    Date(Year(Today()), Month(Today()), 25)) 

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------