Skip to main content
Question

Field that is the same day every month

  • October 8, 2020
  • 0 replies
  • 18 views

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
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+22
  • Quickbase Alumni
  • October 8, 2020
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
------------------------------