Problems with Dateadd function iin Ms Access

Copper Contributor

The Dateadd function is giving me the following error

 

clipboard_image_0.png

I amm using the following exptression DateAdd ("d", 14, [Uitbetalingsdata 2017]![Datum van] )

Sorry my apps are mostly Dutc based

4 Replies
I aws using The European style for number formatting. What separator should I use when I am using "."as digtal grouping and he "'" as decimal symbol.
In Excell I used the ";"
Thank you this is my name phedeme I want the full access

@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])

@tsgiannis

In my region I have the ";"as sepatator but 

clipboard_image_0.png