Skip to Content
0
Former Member
Dec 04, 2008 at 06:24 AM

docdate search for current posting period

64 Views

Hi!

when I am searching for documents within a period of time, I would like the existing value of the start date to show from the start of current posting period, rather than the first posted document as an option.

For example, I use the following code

Select ...... where Docdate between %1 and %2

The existing values for %1 shows from the very first posted document. How do I make it to show only from the start of the current posting period? I want to override it by entering a date which might be before the current posting period as well.

How do I do this?

Prajwal