Skip to Content
0

Approval Query based on a Date

Feb 27, 2017 at 02:28 AM

53

avatar image
Former Member

Hi!

I need help with an approval query that will be based on the posting date of a document. For example, if a user creates a Sales Order that is dated on any day for the month of February, this document would have to undergoe approval process.

Thank you!

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Nagarajan K Feb 27, 2017 at 04:53 AM
0

Hi,

Try this query,

SELECT Distinct 'True' FROM ORDR T0 WHERE datename(mm,$[ORDR.DocDate]) = 'February'

Regards,

Nagarajan

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Feb 27, 2017 at 04:53 AM
0

Hello,

Try This

IF Month($[ORDR.DocDate.Date])  = 2 
Select 'True'


Thanks

Engr. Taseeb Saeed

Share
10 |10000 characters needed characters left characters exceeded