Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2009
    Posts
    5

    Lightbulb Unanswered: MAS90 Sales module export based on selected date

    hi,

    I want to export records from Sales_History table on the basis of
    a date. (My main purpose is to export only new records for a day)

    But on "Select Tab" if I put relation "Equal To" and
    Selection Value = "03/14/2007" it does not export any records,
    even though records for the selected date are available.

    On the "Data Tab" mask for the Invoice Date is like:
    1~~~%Mz~/~%Dz~/~%Y

    I have tried putting the date in all possible formats but nothing worked.

    Could anybody guide me for this?

    Thanks,
    Smruti.

  2. #2
    Join Date
    Mar 2009
    Posts
    5
    Found the solution.
    the date should be put without separator i.e.
    like 20070314.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •