CODEWITHSUNDEEP
sqlms-accesssyntax
lyancsie
lyancsie

Reputation: 678

Ms Access Syntax issues

My problem is that I would like to realize this, but it throws syntax error.

WorkDayUltimate: Format(DateAdd("mm/dd/yy","h",-6,[Outgoing Date])

Thanks for your help in advance.

Upvotes: 2

Views: 41

Answers (1)

Gustav
Gustav

Reputation: 55806

You must first add to date, then format:

WorkDayUltimate: Format(DateAdd("h",-6,[Outgoing Date]),"mm/dd/yy")

Upvotes: 1

Related Questions