cancel
Showing results for 
Search instead for 
Did you mean: 

Approval Query based on a Date

0 Kudos

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!

Accepted Solutions (0)

Answers (2)

Answers (2)

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Try this query,

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

Regards,

Nagarajan

Former Member
0 Kudos

Hello,

Try This

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


Thanks

Engr. Taseeb Saeed