Forum Discussion
Problems with Dateadd function iin Ms Access
The Dateadd function is giving me the following error I amm using the following exptression DateAdd ("d", 14, [Uitbetalingsdata 2017]![Datum van] ) Sorry my apps are mostly Dutc based
Siegfried1951 When you are writing expressions in Queries/Forms/Reports without VBA the syntax always follows your system ...
e.g For my system the separator is ";" ...and lets say you want to populate an unbound TextBox on your form ...so the ControlSource is :
DateAdd ("d"; 14; [Uitbetalingsdata 2017]![Datum van] )
if you are writing VBA then it has the comma as separator
dateadd("d",14,n[Uitbetalingsdata 2017]![Datum van])
