TammyChurchill
5 years agoQrew Trainee
Field that is the same day every month
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
------------------------------
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
------------------------------