When using dateadd function you can add the number of day indicated to your date in a query. I want to add a specified number of days to the [recdt] field in a query but I want only workdays added. From research, I understand that I should use dateaddw([recdt],3) but it keeps saying undefined function.
Here is what I have in my query.
Recdt field in first column and out:dateaddw(recdt],3) in the second column.
Could someone please tell me how to add 3 workdays to the recdt column and make it work?
I found that too - I think the one I linked to was a copy and paste job.
Have you followed the instructions in the link? The query looks fine and the error message indicates something else: You will need to copy and paste the DateAddW function into a new, blank module in your database. You will then not get the "undefined function" method and your query should work.
the aim is store once, not store multiple times
Remember... Optimize 'til you die!
Progaming environment: Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010 VB based on my own environment: vb6 sp5 ASP based on my own environment: 5.6 VB-NET based on my own environment started 2007 SQL-2005 based on my own environment started 2008 MYLE YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.