Error in dateadd sql function

0

Hi

in the domain calculated field I need to use the following SQL function "DATEADD(dd,7,GETDATE())' but I got "cannot evaluate expression" 

If I add ' to dd parameter (DATEADD('dd',7,GETDATE()) I'm able to save but I get a SQL error in the Ad Hoc view execution

Please is there any suggestion ?

Product version is 6.3 Enterprise

 

marco.colombo's picture
Joined: Sep 14 2016 - 7:23am
Last seen: 1 month 2 weeks ago

2 Answers:

0

try 

DATEADD(day, 1, GETDATE())
kaushiklokesh123's picture
Joined: Dec 1 2015 - 11:07pm
Last seen: 2 months 2 weeks ago
0

Thanks but unfortunately I get the same error 

marco.colombo's picture
Joined: Sep 14 2016 - 7:23am
Last seen: 1 month 2 weeks ago
Feedback