Set Date Range with Script

[Matt Leach]

I've setup a report in my database to display records based on a date range. The problem im running into is pluggin the start and end dates into a script, have never really done any scripting with ranges of dates.

I have a field called "closed_date" which is the date i want to set a range for. Ive setup fields for ClosedDateStart and ClosedDateEnd and used those fields in a custom dialog. Here is the script i have so far:

Show Custom Dialog [ Title: "Input Date Range"; Message: "Please Specify the date range you would like to use ont he report"; Buttons: “OK”,

“Cancel”; Input #1: Investigation::ClosedDateStart, "Start Date"; Input #2: Investigation::ClosedDateEnd, "End Date" ]



Go to Layout [ “Case_Hours” (Investigation) ]



Enter Find Mode [ ][ Pause ]



Set Field By Name [ Investigation::Closed_Date ]

My question is how do i set the Closed_Date field to be a range of dates. 



Would i need to do something like:

> ClosedDateStart < ClosedDateEnd

Thanks for any help

[Richard Corso]

Hello

You will first have to create two fields Start and End. Here is the script that I am using in my DB

Set Error Capture [ On ]

Show Custom Dialog [ Title: "Penny Log"; Message: "Please enter the dates that you'd like to search by.If you would like to search all records, leave the date fields empty.¶¶Valid dates

are :Start 1/9/2009 End 6/25/2009"; Buttons: “OK”; Input #1: main::Start, "Start"; Input #2: main::End, "End" ]

Set Variable [ $FromDate; Value:main::Start ]

Set Variable [ $ToDate; Value:main::End ]

New Window [ Name: "Search Penny Log"; Height: 600; Width: 600; Top: 50; Left: 200 ]

Go to Layout [ “pennylog” (pennylog) ]

Enter Find Mode [ ]

Set Field [ pennylog::Date; $FromDate & "..." & $ToDate ]

Perform Find [ ]

Show/Hide Status Area

[ Lock; Show ]

Move/Resize Window [ Current Window; Width: 855 ]

Halt Script

Hope this works for you, if not let me know.

Date.zip

Edited May 11, 2010 by Guest

[Matt Leach]

That cleared it up, thank you very much for the example.

[Richard Corso]

I'm glad it worked for you, good luck