Tables: How to set a default value of a date field to an upcoming date of the 1st or the 15th

[ExtremeNovice]

I am building a payroll oriented database and learning Access as I go. I have a field titled 'DateWorked' and a field titled 'PayDate' in my table. Once I have entered the 'DateWorked' I would like my 'PayDate' field to default to the next upcoming pay date, which depending on when the data is entered, would be 15th of the current month or the 1st of the next month. Thanks!

[Micron]

You are using a form, yes? Don't add or update information in tables, as a rule (not sure, but your post title could be saying this is the case). If this is in a form and the dates you need are not table record values, an unbound textbox can be used along with a complicated expression to compare the "Day part" of the DateWorked value's Day part against the current date, and if less than 15, use the 15th of the current month, else use the first of the next month. Personally, I keep a safe distance from complicated IIF expressions - they hurt my head. You could also use a custom function to return the correct date.

If the dates are table values, a different approach would be used.