Guest User

Untitled

a guest
Jun 19th, 2018
105
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.35 KB | None | 0 0
  1. @SQL=SELECT date_trunc( 'month', (SELECT date_trunc(CAST('month' AS VARCHAR) , CAST(@DateInvoiced@ AS TIMESTAMP)))
  2.  + (SELECT fixmonthoffset*31
  3.     FROM xpsa_doctype_voidrestrictions vr
  4.     WHERE vr.c_doctype_id=@C_DocTypeTarget_ID@))
  5. + (SELECT fixdayoffset
  6.     FROM xpsa_doctype_voidrestrictions vr
  7.     WHERE vr.c_doctype_id=@C_DocTypeTarget_ID@)
  8. -1 >= CURRENT_DATE
Add Comment
Please, Sign In to add comment