Setting upcoming Friday as default value

[Milgrl3]

Hello All,



I am a newbie to this site and need some help for work. I am creating a database in Access 2013 and one of my fields is "Week Of." I want this field to auto populate the upcoming Friday and I am in need of help! I have used different expressions to do this but nothing is working for me.

[JoeM]

This calculation should do that:

IIf(Weekday(Date(),6)=1,Date(),Date()+8-Weekday(Date(),6))

[Milgrl3]

I get an error message that "the expression you entered has a function name that Microsoft Access can't find." This is the error message I keep getting every time.

[JoeM]

Where exactly are you entering this calculation?
Are you doing it in a query or in a text box on a Form or Report?

[Milgrl3]

It is a default value in a field on a table:



Needs to be a table because I am going to be using this in a web app as well.

[JoeM]

You cannot use formulas in field Default Values.

If you control all data entry through forms, you can include VBA code that populates this field with a similar VBA calculation upon data entry.
Or, if you are importing data, you can use an Update Query to update this field with this calculation afterwards.

[Milgrl3]

Ended up giving up on the Access Web App. Going to try another avenue to create this database and add it to our shared drive. What would be the code to add to a form? That I can definitely try!