Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- @SQL=SELECT date_trunc( 'month', (SELECT date_trunc(CAST('month' AS VARCHAR) , CAST(@DateInvoiced@ AS TIMESTAMP)))
- + (SELECT fixmonthoffset*31
- FROM xpsa_doctype_voidrestrictions vr
- WHERE vr.c_doctype_id=@C_DocTypeTarget_ID@))
- + (SELECT fixdayoffset
- FROM xpsa_doctype_voidrestrictions vr
- WHERE vr.c_doctype_id=@C_DocTypeTarget_ID@)
- -1 >= CURRENT_DATE
Add Comment
Please, Sign In to add comment