Method:Classic General Q&A

Re: SQL Now(), DateDiff() function

Method_Ben — Mon, 11 Apr 2016 16:38:29 GMT

Thanks for the post bergyver.

Definitely a handy reference to have. Im sure lots of people will benefit from this!

-Ben

Re: SQL Now(), DateDiff() function

bergyver — Sun, 10 Apr 2016 03:38:26 GMT

I was painstakingly working on this and found that if you use the convert function that it displays the format of the date you want and also allows the grid to not have issues.

CONVERT(varchar(10), GETDATE (), 101)

I did find that GetDate() is working where now() and today() does not work.

Peace!

CONVERT(varchar(10), GETDATE (), 101)

Re: SQL Now(), DateDiff() function

Method_Justin — Fri, 20 Mar 2015 20:53:46 GMT

Hi Alex,

SQL Overrides are outside the scope of what we can really provide help with here on the forums, but you could try using GETDATE(). I'm not 100% certain if it will work, but you can give it a shot.

If you'd like to go over some more advanced customization concepts, you would likely benefit from booking some time with a member of our Professional Services Team. Let me know if that interests you and I'll have your account manager follow up.

Hope this helps.

- Justin

SQL Now(), DateDiff() function

alexhuang — Fri, 20 Mar 2015 16:50:17 GMT

Hi Method,

For SQL override, does Method system support Now() and DateDiff() function? I'm trying them but the grid always show "Error Generating Grid".

Thanks.

Alex