Generate Date for the first of the following month

Joined
Jul 1, 2007
Messages
1
Reaction score
0
I have a form that has a field for the date the record was created with Date() as a default value. I also want to set a default value for a field that represents the start date of membership. If the application comes in between the 1st-15th it starts on the first of the current month. If it comes in between the 16th and the 31st the date should be set to the 1st day of the following month.

I would appreciate help on how to write the expression to set the default value for the field.

Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top