Skip to Content
avatar image
Former Member

Approval Query based on a Date

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!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Feb 27, 2017 at 04:53 AM

    Hi,

    Try this query,

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

    Regards,

    Nagarajan

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 27, 2017 at 04:53 AM

    Hello,

    Try This

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

    Thanks

    Engr. Taseeb Saeed

    Add comment
    10|10000 characters needed characters exceeded