Javier, that's pretty cool. The logic is essentially the same as the solution I found, but mine is table-based/data-driven, so I suspect that yours works faster. I'll test that and see if there's a difference.
Wish I'd thought of your approach. Thanks, Steve From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Javier Valencia Sent: Tuesday, March 11, 2008 9:42 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: DIALOG BOX Steve: In this case, it is used as calendar dates but I have another application where the FY is used and whenever the FY is needed, it is calculated as follows: I have global system variables that are read when the user logs in that store the start month and day for the defined Fiscal Year; for example, the Federal Fiscal year starts on October 1 and runs through September 30 of the next year. The variables: vFYMonth = 10 and vFYDay = 1 Now, whenever I need to calculate the Fiscal Year for any date (vTestDate), I use the following formula: SET VAR vFY = (IFLT(.vTestDate, (RDATE(.vFYMonth,.vFYDay,IYR(.vTestDate))),(IYR(.vTestDate)), (IYR(.vTestDate) + 1) ) ) This will give you the correct Fiscal Year. If another application has a different fiscal year, all you do is change the global values and it should calculate correctly. Javier, -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Wills, Steve Sent: Tuesday, March 11, 2008 8:51 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: DIALOG BOX Javier, out of curiosity, how do you manage your fiscal versus calendar time-periods? I ask because I posted a message a couple of weeks ago with what I thought was a pretty good solution. Maybe everybody else already had a good solution, but I got only one reply. Anyway, I'm curious. Thanks, Steve in Memphis From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Javier Valencia Sent: Tuesday, March 11, 2008 8:43 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: DIALOG BOX Steve:: I have created a form called DateFromTo that has many radio buttons including: Today Current Week Current Month Current Quarter Current Year Yesterday Previous Week Previous Month Previous Quarter Previous Year The form also has fields for >From Date To Date That can be specifically selected. When the user selects any of the radio buttons, the From Date and To Date fields are automatically updated but the user can override one or both values; you can also specify what the default dates are. I use this form any time I need to get date inputs from the user and it work great and has a lot more flexibility than the DIALOG command. Javier, ________________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Steve Breen Sent: Tuesday, March 11, 2008 7:36 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: DIALOG BOX Here is another dialog box question. Can you make more than one entry in a dialog box? IE: begining date and ending date Or do you have to use two different dialog box entries to accomplish this? -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of Steve Breen Sent: Monday, March 10, 2008 4:46 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: DIALOG BOX Thanks -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of Adrian Huessy Sent: Monday, March 10, 2008 4:38 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: DIALOG BOX Steve Have a look at this code: DIALOG 'Type Message Here ...' vResponse vEndKey YES CAPTION 'Type Caption Here ...' ICON INFO + OPTION MESSAGE_FONT_NAME Agency FB|MESSAGE_FONT_SIZE 11|MESSAGE_BOLD ON Regards Adrian ________________________________________ From: Steve Breen [mailto:[EMAIL PROTECTED] Sent: Monday, March 10, 2008 9:35 PM To: [email protected] Subject: [RBASE-L] - DIALOG BOX Is there a way to control font size in a dialog box ? Stephen Breen CDI Services, Inc. Road Support Division
