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