Home

Problems with Dateadd function iin Ms Access

%3CLINGO-SUB%20id%3D%22lingo-sub-853580%22%20slang%3D%22en-US%22%3EProblems%20with%20Dateadd%20function%20iin%20Ms%20Access%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-853580%22%20slang%3D%22en-US%22%3E%3CP%3EThe%20Dateadd%20function%20is%20giving%20me%20the%20following%20error%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F131593i398CF533DC16E982%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22clipboard_image_0.png%22%20title%3D%22clipboard_image_0.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EI%20amm%20using%20the%20following%20exptression%26nbsp%3BDateAdd%20(%22d%22%2C%2014%2C%20%5BUitbetalingsdata%202017%5D!%5BDatum%20van%5D%20)%3C%2FP%3E%3CP%3ESorry%20my%20apps%20are%20mostly%20Dutc%20based%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-853580%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%202016%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-853683%22%20slang%3D%22en-US%22%3ERe%3A%20Problems%20with%20Dateadd%20function%20iin%20Ms%20Access%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-853683%22%20slang%3D%22en-US%22%3EI%20aws%20using%20The%20European%20style%20for%20number%20formatting.%20What%20separator%20should%20I%20use%20when%20I%20am%20using%20%22.%22as%20digtal%20grouping%20and%20he%20%22'%22%20as%20decimal%20symbol.%3CBR%20%2F%3EIn%20Excell%20I%20used%20the%20%22%3B%22%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-853694%22%20slang%3D%22en-US%22%3ERe%3A%20Problems%20with%20Dateadd%20function%20iin%20Ms%20Access%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-853694%22%20slang%3D%22en-US%22%3EThank%20you%20this%20is%20my%20name%20phedeme%20I%20want%20the%20full%20access%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-853915%22%20slang%3D%22en-US%22%3ERe%3A%20Problems%20with%20Dateadd%20function%20iin%20Ms%20Access%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-853915%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F408221%22%20target%3D%22_blank%22%3E%40Siegfried1951%3C%2FA%3E%26nbsp%3BWhen%20you%20are%20writing%20expressions%20in%20Queries%2FForms%2FReports%20without%20VBA%20the%20syntax%20always%20follows%20your%20system%20...%3C%2FP%3E%3CP%3Ee.g%20For%20my%20system%20the%20separator%20is%26nbsp%3B%20%22%3B%22%20...and%20lets%20say%20you%20want%20to%20populate%20an%20unbound%20TextBox%20on%20your%20form%20...so%20the%20ControlSource%20is%20%3A%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EDateAdd%20(%22d%22%3B%2014%3B%20%5BUitbetalingsdata%202017%5D!%5BDatum%20van%5D%20)%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3Eif%20you%20are%20writing%20VBA%20then%20it%20has%20the%20comma%20as%20separator%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3Edateadd(%22d%22%2C14%2Cn%5BUitbetalingsdata%202017%5D!%5BDatum%20van%5D)%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-854395%22%20slang%3D%22en-US%22%3ERe%3A%20Problems%20with%20Dateadd%20function%20iin%20Ms%20Access%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-854395%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F401564%22%20target%3D%22_blank%22%3E%40tsgiannis%3C%2FA%3E%3C%2FP%3E%3CP%3EIn%20my%20region%20I%20have%20the%20%22%3B%22as%20sepatator%20but%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F131698iC117A1E75F6D6F76%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22clipboard_image_0.png%22%20title%3D%22clipboard_image_0.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Siegfried1951
New 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

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies