Sep 12 2019 03:40 PM
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
Sep 12 2019 05:46 PM
Sep 12 2019 06:30 PM
Sep 12 2019 11:18 PM
@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])
Sep 13 2019 06:23 AM