Forum Discussion

TammyChurchill's avatar
TammyChurchill
Qrew Trainee
4 years ago

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
------------------------------