Date Parameters

pbrad · Post by **pbrad** » Sun Feb 10, 2008 11:50 pm

Hi,

I have a non persisted form that I am using to set search parameters for a query. I would like to pre-populate a date field with the first day of the current month.

I am not having any luck getting the 'default value' equal to anything more complicated that CURRENT_DATE. I have also tried to set an initialization rule which I would have thought should work but doesn't. My third approach has been to use a process. Could you please steer me in the right direction?

ENTER NEW SalesSummaryReportParameters WITH SalesSummaryReportParameters.FromDate=FIRST_DAY_OF_MONTH

Thanks,
Pete

aware_support · Post by **aware_support** » Mon Feb 11, 2008 3:13 am

An initialization rule approach should definitely work. Just make sure that you check "use in initialization" flag in the Advanced properties of the rule.

Do not use the process for this.

pbrad · Post by **pbrad** » Mon Feb 11, 2008 2:19 pm

Thanks,

I fiddled with the syntax for awhile before I found that putting CURRENT_DATE in the brackets makes it work:

If SalesSummaryReportParameters.FromDate IS UNDEFINED Then
SalesSummaryReportParameters.FromDate=FIRST_DAY_OF_MONTH(CURRENT_DATE)

Thanks,
Pete