33 days from invoiced date

When we print invoices, we offer a 25% discount if they pay within 33 days from the date of invoice. Can anyone help with a formula that would show the date 33 days from printed invoice date? As always, thanks!See the help on the DateAdd function.|||Something like this should work. ( I took a guess at your field name )

{Orders.Invoice Date} + 33

24h/7d Time Periods TO 10h/5d Time Periods

I have to do alot of date calculations. For some calculations, I can use the datediff or dateadd function to get a Time Period between 2 dates.

Now for some dates I need to calculate the time between 2 dates BUT:

a week = 5 days starting from Monday to Friday a day starts at 8AM and ends at 6PM (so a day is 10 hours)

You can probably calculate this manually but what about summer to winter hour and the month Februari when it has 29 days etc.

So I was thinking ... is it possible to calculate the Time Period for weeks with 24h a day / 7 days AND then transform that Time Period to a time period for weeks with 10h a day / 5 days ?

If anyone has an idea to solve this, either with functions or an other way, please let me know! Thanks

For our internal help desk application I created the following user-defined function to calculate the hours between 8am and 5pm Monday - Friday. There are obvious holes, but it fell within the management guidelines for their reporting:

CREATE FUNCTION [dbo].fnGetWorkHours
(@.start_dt datetime=null, @.end_dt datetime=null, @.co_user_id int=null)
RETURNS int

AS
-- Returns the number of weekday hours between the supplied dates
BEGIN
declare @.d1 datetime, @.d2 datetime, @.d1a datetime, @.d2a datetime, @.hours int, @.offset int

set @.offset = 0
if @.co_user_id is not null
begin
select @.offset = l.timezone_offset
from [HelpDesk].[dbo].[Company_User] c INNER JOIN [HelpDesk].[dbo].[Location_Def] l
on c.[loc_id] = l.[loc_id]
where c.co_user_id = @.co_user_id
end

set @.d1 = dateadd(hour, @.offset, @.start_dt)
set @.d2 = dateadd(hour, @.offset, @.end_dt)

if convert(char(10),@.d1,101) = convert(char(10),@.d2,101)
BEGIN
SELECT @.hours = DATEDIFF(hour, @.d1, @.d2)
END
ELSE
BEGIN
SET @.d1 = CASE WHEN @.d1 > convert(char(10),@.d1,101) + ' 17:00' THEN convert(char(10),dateadd(day,1,@.d1),101) + ' 08:00'
ELSE @.d1 END
SET @.d2 = CASE WHEN @.d2 < convert(char(10),@.d2,101) + ' 08:00' THEN convert(char(10),@.d2,101) + ' 08:00'
ELSE @.d2 END
SET @.d1 = CASE WHEN DATEPART(weekday,@.d1+@.@.DATEFIRST)=1 THEN convert(char(10),dateadd(day,1,@.d1),101) + ' 08:00'
WHEN DATEPART(weekday,@.d1+@.@.DATEFIRST)=7 THEN convert(char(10),dateadd(day,2,@.d1),101) + ' 08:00'
ELSE @.d1 END
SET @.d2 = CASE WHEN DATEPART(weekday,@.d2+@.@.DATEFIRST)=1 THEN convert(char(10),dateadd(day,-2,@.d2),101) + ' 17:00'
WHEN DATEPART(weekday,@.d2+@.@.DATEFIRST)=7 THEN convert(char(10),dateadd(day,-1,@.d2),101) + ' 17:00'
ELSE @.d2 END
set @.d1a = dateadd(day,1,@.d1)
set @.d2a = dateadd(day,-1,@.d2)
SELECT @.hours =
CASE WHEN DATEDIFF(day, @.d1, @.d2) > 1 THEN
(DATEDIFF(day, @.d1a, @.d2a) + 1 - (2 * DATEDIFF(week, @.d1, @.d2))) * 8
ELSE 0 END +
CASE WHEN convert(char(10),@.d1,101) = convert(char(10),@.d2,101)
THEN DATEDIFF(hour, @.d1, @.d2)
WHEN convert(char(10),@.d1,101) < convert(char(10),@.d2,101)
THEN DATEDIFF(hour, @.d1, convert(char(10),@.d1,101) + ' 17:00')
ELSE 0 END +
CASE WHEN DATEDIFF(day, @.d1, @.d2) > 0 THEN
DATEDIFF(hour, convert(char(10),@.d2,101) + ' 08:00', @.d2)
ELSE 0 END
END
RETURN(@.hours)
END
go

|||Best is to build a calendar table with the possible dates, columns that track working days, holidays, time adjustments etc. You can then easily write queries to answer your questions. It is possible to write scalar UDFs but the logic for those will often be complicated and hard to use if you want to support different types of calculations easily.

24 hr date format

couldn't find 24 hr(military) date format

thanks

Just use the Format() function, like this:

Code Snippet

Format( CDate([your field]), "HH:mm:ss")

or

Code Snippet

Format( CDate([your field]), "yyyyMMdd HH:mm:ss")

Hope that helps.

|||

Thanks. How can I subtract one datetime (2007-02-02 10:11:11) to another datetime(2007-02-02 11:10:10) and put negatives in bracket(red)

thanks in advance

|||

Here is an expression you can use to evaluate how many days difference there are between two dates:

Code Snippet

=DateDiff("d", CDate(Fields!FirstDate.Value), CDate(Fields!SecondDate.Value))

To subtract a specific number of days from a date use this (just change the -1 to whatever quantity you require):

Code Snippet

=DateAdd("d", -1, CDate(Fields!MyDate.Value))

To show a negative value in red, use an IIf statement in the Color property of the cell or textbox, like this:

Code Snippet

=IIf( [my date expression] < 0, "Red", "Black")

|||Thanks again..this thing will give me just the number of days , I am trying get the out put in the format -hh:mms and then if it is negative keep it in a bracket(hh:mms)|||

Hello,

Try this to get the difference in the format you require:

=Iif(DateDiff("s", Fields!FirstDate.Value, Fields!SecondDate.Value) < 0, "(", "")

+ cStr(abs(DateDiff("h", Fields!FirstDate.Value, Fields!SecondDate.Value)))

+ ":"

+ Format(abs(DateDiff("n", Fields!FirstDate.Value, Fields!SecondDate.Value) mod 60), "00")

+ ":"

+ Format(abs(DateDiff("s", Fields!FirstDate.Value, Fields!SecondDate.Value) mod 60), "00")

+ Iif(DateDiff("s", Fields!FirstDate.Value, Fields!SecondDate.Value) < 0, ")", "")

Then, if you want the negative values to be in red, enter this in the color property expression.

=Iif(DateDiff("s", Fields!FirstDate.Value, Fields!SecondDate.Value) < 0, "Red", "Black")

This will display in red if FirstDate is after the SecondDate.

Hope this helps.

Jarret

|||

A slightly more efficient way to do it is to abstract that code into a custom function, like this:

Code Snippet

Public Function TimeDiff(firstDate As String, secondDate As String) As String

Dim timeDifference As String
timeDifference = Abs(DateDiff("h", CDate(firstDate), CDate(secondDate))) & Format(CDate(firstDate) - CDate(secondDate), ":nn:ss")

If CDate(firstDate) > CDate(secondDate) Then
timeDifference = "-(" & timeDifference & ")"
End If

TimeDiff = timeDifference
End Function

then you can just call it from your cell with an expression like this:

Code Snippet

=Code.TimeDiff(Fields!FirstDate.Value, Fields!SecondDate.Value)

Or you can simplify the previously posted code into an expression directly in the cell:

Code Snippet

=IIf(
CDate(Fields!firstDate.Value) <= CDate(Fields!secondDate.Value),
Abs(DateDiff("h", CDate(Fields!firstDate.Value), CDate(Fields!secondDate.Value))) & Format(CDate(Fields!firstDate.Value) - CDate(Fields!secondDate.Value), ":nn:ss"),
"-(" & Abs(DateDiff("h", CDate(Fields!firstDate.Value), CDate(Fields!secondDate.Value))) & Format(CDate(Fields!firstDate.Value) - CDate(Fields!secondDate.Value), ":nn:ss") & ")"
)

You have already been shown two different expressions to colour the text, and you have been given two complete correct answers by two different people - i think you have enough to finish this one off and get your report looking good

2005 Table Partitioning

Hi - can anyone tell me how I can query which filegroup a particular
partition number belongs to'
For example I have a date range partition function & the query:
SELECT PartitionNo = $partition.DateRangePFN ('20070401')
Tells me this date would be placed in partition number 2 which should be in
a Filegroup called "April" but I just wanted to check that partition 2 is
actually mapped to filegroup April & I can't see how to do it!!
Thanks!!
MikeOn Jun 8, 3:56 pm, "Michael Knee" <mike...@.hotmail.com> wrote:
> Hi - can anyone tell me how I can query which filegroup a particular
> partition number belongs to'
> For example I have a date range partition function & the query:
> SELECT PartitionNo = $partition.DateRangePFN ('20070401')
> Tells me this date would be placed in partition number 2 which should be in
> a Filegroup called "April" but I just wanted to check that partition 2 is
> actually mapped to filegroup April & I can't see how to do it!!
> Thanks!!
> Mike
select
prv.boundary_id,
prv.value,
fg.name
from
sys.partition_range_values prv
inner join
sys.partition_functions pf on prv.function_id = pf.function_id
inner join
sys.destination_data_spaces dds on dds.destination_id =prv.boundary_id
inner join
sys.filegroups fg on fg.data_space_id = dds.data_space_id
where
pf.name = 'PF_DateRange'
and
prv.boundary_id = $partition.PF_DateRange('20050814')
See http://weblogs.sqlteam.com/dmauri/archive/2005/08/20/7593.aspx|||Exactly what I was after & excellent blog link as well - Thank You!
Mike
"M A Srinivas" <masri999@.gmail.com> wrote in message
news:1181303483.375856.68170@.r19g2000prf.googlegroups.com...
> On Jun 8, 3:56 pm, "Michael Knee" <mike...@.hotmail.com> wrote:
>> Hi - can anyone tell me how I can query which filegroup a particular
>> partition number belongs to'
>> For example I have a date range partition function & the query:
>> SELECT PartitionNo = $partition.DateRangePFN ('20070401')
>> Tells me this date would be placed in partition number 2 which should be
>> in
>> a Filegroup called "April" but I just wanted to check that partition 2 is
>> actually mapped to filegroup April & I can't see how to do it!!
>> Thanks!!
>> Mike
> select
> prv.boundary_id,
> prv.value,
> fg.name
> from
> sys.partition_range_values prv
> inner join
> sys.partition_functions pf on prv.function_id = pf.function_id
> inner join
> sys.destination_data_spaces dds on dds.destination_id => prv.boundary_id
> inner join
> sys.filegroups fg on fg.data_space_id = dds.data_space_id
> where
> pf.name = 'PF_DateRange'
> and
> prv.boundary_id = $partition.PF_DateRange('20050814')
>
> See http://weblogs.sqlteam.com/dmauri/archive/2005/08/20/7593.aspx
>

2005 Table Partitioning

Hi - can anyone tell me how I can query which filegroup a particular
partition number belongs to'
For example I have a date range partition function & the query:
SELECT PartitionNo = $partition.DateRangePFN ('20070401')
Tells me this date would be placed in partition number 2 which should be in
a Filegroup called "April" but I just wanted to check that partition 2 is
actually mapped to filegroup April & I can't see how to do it!!
Thanks!!
MikeOn Jun 8, 3:56 pm, "Michael Knee" <mike...@.hotmail.com> wrote:
> Hi - can anyone tell me how I can query which filegroup a particular
> partition number belongs to'
> For example I have a date range partition function & the query:
> SELECT PartitionNo = $partition.DateRangePFN ('20070401')
> Tells me this date would be placed in partition number 2 which should be i
n
> a Filegroup called "April" but I just wanted to check that partition 2 is
> actually mapped to filegroup April & I can't see how to do it!!
> Thanks!!
> Mike
select
prv.boundary_id,
prv.value,
fg.name
from
sys.partition_range_values prv
inner join
sys.partition_functions pf on prv.function_id = pf.function_id
inner join
sys.destination_data_spaces dds on dds.destination_id =
prv.boundary_id
inner join
sys.filegroups fg on fg.data_space_id = dds.data_space_id
where
pf.name = 'PF_DateRange'
and
prv.boundary_id = $partition.PF_DateRange('20050814')
See http://weblogs.sqlteam.com/dmauri/a...08/20/7593.aspx|||Exactly what I was after & excellent blog link as well - Thank You!
Mike
"M A Srinivas" <masri999@.gmail.com> wrote in message
news:1181303483.375856.68170@.r19g2000prf.googlegroups.com...
> On Jun 8, 3:56 pm, "Michael Knee" <mike...@.hotmail.com> wrote:
> select
> prv.boundary_id,
> prv.value,
> fg.name
> from
> sys.partition_range_values prv
> inner join
> sys.partition_functions pf on prv.function_id = pf.function_id
> inner join
> sys.destination_data_spaces dds on dds.destination_id =
> prv.boundary_id
> inner join
> sys.filegroups fg on fg.data_space_id = dds.data_space_id
> where
> pf.name = 'PF_DateRange'
> and
> prv.boundary_id = $partition.PF_DateRange('20050814')
>
> See http://weblogs.sqlteam.com/dmauri/a...08/20/7593.aspx
>

2005 Service Pack 2 Release Version schedule

Greetings,
I'm looking for a scheduled release date for Service Pack 2 for SQL Server
2005.
Thanks,
Mike Hayes
> I'm looking for a scheduled release date for Service Pack 2 for SQL Server
> 2005.
There is no such thing.
The release date will be largely based, I would guess, on how much
[negative] feedback is obtained from the SP2 CTP. Which you can download,
kick the tires, and report any problems at connect.microsoft.com:
http://www.microsoft.com/sql/ctp.mspx
Other than that, as Tibor mentioned, we can guess, but there are no
announced dates, because it is not based on a date, but rather WHEN IT'S
READY.
A
|||At the keynote at PASS, Paul Flessner I believe stated that SP2 would likely
be out in "early Q1." Of course that is not an official announcement, and
it really could mean anytime between January 1st and March 31st. Or later,
if it's simply not ready.
"Mike Hayes" <Mike Hayes@.discussions.microsoft.com> wrote in message
news:197E3D6C-2878-4122-9D2B-747061E25C59@.microsoft.com...
> Greetings,
> I'm looking for a scheduled release date for Service Pack 2 for SQL Server
> 2005.
> Thanks,
> Mike Hayes

2005 Service Pack 2 Release Version schedule

Greetings,
I'm looking for a scheduled release date for Service Pack 2 for SQL Server
2005.
Thanks,
Mike HayesMS do not decide on such dates. The official response is "when it is ready".
It is in RC2 now, so
based on that, we can *guess* that it might be 1.5-2 months away, but nobody
knows.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Mike Hayes" <Mike Hayes@.discussions.microsoft.com> wrote in message
news:197E3D6C-2878-4122-9D2B-747061E25C59@.microsoft.com...
> Greetings,
> I'm looking for a scheduled release date for Service Pack 2 for SQL Server
> 2005.
> Thanks,
> Mike Hayes|||> I'm looking for a scheduled release date for Service Pack 2 for SQL Server
> 2005.
There is no such thing.
The release date will be largely based, I would guess, on how much
[negative] feedback is obtained from the SP2 CTP. Which you can downloa
d,
kick the tires, and report any problems at connect.microsoft.com:
http://www.microsoft.com/sql/ctp.mspx
Other than that, as Tibor mentioned, we can guess, but there are no
announced dates, because it is not based on a date, but rather WHEN IT'S
READY.
A|||At the keynote at PASS, Paul Flessner I believe stated that SP2 would likely
be out in "early Q1." Of course that is not an official announcement, and
it really could mean anytime between January 1st and March 31st. Or later,
if it's simply not ready.
"Mike Hayes" <Mike Hayes@.discussions.microsoft.com> wrote in message
news:197E3D6C-2878-4122-9D2B-747061E25C59@.microsoft.com...
> Greetings,
> I'm looking for a scheduled release date for Service Pack 2 for SQL Server
> 2005.
> Thanks,
> Mike Hayes

2005 Service Pack 2 Release Version schedule

Greetings,
I'm looking for a scheduled release date for Service Pack 2 for SQL Server
2005.
Thanks,
Mike HayesMS do not decide on such dates. The official response is "when it is ready". It is in RC2 now, so
based on that, we can *guess* that it might be 1.5-2 months away, but nobody knows.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Mike Hayes" <Mike Hayes@.discussions.microsoft.com> wrote in message
news:197E3D6C-2878-4122-9D2B-747061E25C59@.microsoft.com...
> Greetings,
> I'm looking for a scheduled release date for Service Pack 2 for SQL Server
> 2005.
> Thanks,
> Mike Hayes|||> I'm looking for a scheduled release date for Service Pack 2 for SQL Server
> 2005.
There is no such thing.
The release date will be largely based, I would guess, on how much
[negative] feedback is obtained from the SP2 CTP. Which you can download,
kick the tires, and report any problems at connect.microsoft.com:
http://www.microsoft.com/sql/ctp.mspx
Other than that, as Tibor mentioned, we can guess, but there are no
announced dates, because it is not based on a date, but rather WHEN IT'S
READY.
A|||At the keynote at PASS, Paul Flessner I believe stated that SP2 would likely
be out in "early Q1." Of course that is not an official announcement, and
it really could mean anytime between January 1st and March 31st. Or later,
if it's simply not ready.
"Mike Hayes" <Mike Hayes@.discussions.microsoft.com> wrote in message
news:197E3D6C-2878-4122-9D2B-747061E25C59@.microsoft.com...
> Greetings,
> I'm looking for a scheduled release date for Service Pack 2 for SQL Server
> 2005.
> Thanks,
> Mike Hayes

2005 Design Studio vs 2000 Enterprise manager

In 2000 you could sort a list of tables in the right hand window pane by
Create Date, Name, etc...
How do you accomplish that in 2005 ?
In Query daesigner you find a toolbar above the panel, (the same toolbar
where you find the "Report" icon. one of the available icons offers you two
ways to view the object conatined in a container: "List" or "Details"; the
default view is "List"; selecting "Details" you obtain a detailed list
organised on a per column basis; selecting a column name you sort the list by
that column (is a toggle: a first click orders ascending, the second orders
descending).
Gilberto Zampatti
"Rob" wrote:

> In 2000 you could sort a list of tables in the right hand window pane by
> Create Date, Name, etc...
> How do you accomplish that in 2005 ?
>
>

2005 Design Studio vs 2000 Enterprise manager

In 2000 you could sort a list of tables in the right hand window pane by
Create Date, Name, etc...
How do you accomplish that in 2005 ?In Query daesigner you find a toolbar above the panel, (the same toolbar
where you find the "Report" icon. one of the available icons offers you two
ways to view the object conatined in a container: "List" or "Details"; the
default view is "List"; selecting "Details" you obtain a detailed list
organised on a per column basis; selecting a column name you sort the list b
y
that column (is a toggle: a first click orders ascending, the second orders
descending).
Gilberto Zampatti
"Rob" wrote:

> In 2000 you could sort a list of tables in the right hand window pane by
> Create Date, Name, etc...
> How do you accomplish that in 2005 ?
>
>

2005 Design Studio vs 2000 Enterprise manager

In 2000 you could sort a list of tables in the right hand window pane by
Create Date, Name, etc...
How do you accomplish that in 2005 ?In Query daesigner you find a toolbar above the panel, (the same toolbar
where you find the "Report" icon. one of the available icons offers you two
ways to view the object conatined in a container: "List" or "Details"; the
default view is "List"; selecting "Details" you obtain a detailed list
organised on a per column basis; selecting a column name you sort the list by
that column (is a toggle: a first click orders ascending, the second orders
descending).
Gilberto Zampatti
"Rob" wrote:
> In 2000 you could sort a list of tables in the right hand window pane by
> Create Date, Name, etc...
> How do you accomplish that in 2005 ?
>
>

2005 Datepicker control and dateformat

Hi, we have an installation of MSSQL reporting services where users
can select data based on date ranges. Since upgrading to 2005 we now
have a nice new Date picker control alongside textareas which accept
MSSQL datetime values.
This is all very nice but the date picker automatically formats the
date to US format mm/dd/yyyy. We need it to be in dd/mm/yyyy format.
I
have checked the regional settings of both the browser/ server etc.
Scouring the Internet seems to point that this is a post SP2 problem
but there seems to be no fix other than making the datefields a type
of nvarchar and then converting them to dates in the Stored
Procedure.
If there really is no fix, how can I just disable this date picker
control? In 2000 people just entered the dates manually, this was
fine
but know there is a date picker control people are obviously going to
use it.
Thanks
RexOn Jul 5, 4:50 pm, Markus...@.gmail.com wrote:
> Hi, we have an installation of MSSQL reporting services where users
> can select data based on date ranges. Since upgrading to 2005 we now
> have a nice new Date picker control alongside textareas which accept
> MSSQL datetime values.
> This is all very nice but the date picker automatically formats the
> date to US format mm/dd/yyyy. We need it to be in dd/mm/yyyy format.
> I
> have checked the regional settings of both the browser/ server etc.
> Scouring the Internet seems to point that this is a post SP2 problem
> but there seems to be no fix other than making the datefields a type
> of nvarchar and then converting them to dates in the Stored
> Procedure.
> If there really is no fix, how can I just disable this date picker
> control? In 2000 people just entered the dates manually, this was
> fine
> but know there is a date picker control people are obviously going to
> use it.
> Thanks
> Rex
Aside from the workarounds you have attempted, that is also all I can
think of. If I understand you correctly, to remove the date time
picker in a specific report you would just select the Layout view ->
Report drop-down tab -> Report Parameters... and select the parameter
you want to remove the date time picker for and then change the Data
type: to something other than DateTime. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||On Jul 6, 10:54 am, EMartinez <emartinez...@.gmail.com> wrote:
> On Jul 5, 4:50 pm, Markus...@.gmail.com wrote:
>
>
> > Hi, we have an installation of MSSQL reporting services where users
> > can select data based on date ranges. Since upgrading to 2005 we now
> > have a nice new Date picker control alongside textareas which accept
> > MSSQL datetime values.
> > This is all very nice but the date picker automatically formats the
> > date to US format mm/dd/yyyy. We need it to be in dd/mm/yyyy format.
> > I
> > have checked the regional settings of both the browser/ server etc.
> > Scouring the Internet seems to point that this is a post SP2 problem
> > but there seems to be no fix other than making the datefields a type
> > of nvarchar and then converting them to dates in the Stored
> > Procedure.
> > If there really is no fix, how can I just disable this date picker
> > control? In 2000 people just entered the dates manually, this was
> > fine
> > but know there is a date picker control people are obviously going to
> > use it.
> > Thanks
> > Rex
> Aside from the workarounds you have attempted, that is also all I can
> think of. If I understand you correctly, to remove the date time
> picker in a specific report you would just select the Layout view ->
> Report drop-down tab -> Report Parameters... and select the parameter
> you want to remove the date time picker for and then change the Data
> type: to something other than DateTime. Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant- Hide quoted text -
> - Show quoted text -
Hi Enrique, thanks for your help. I have found a fix which seems to
work so I'm posting here to help anyone in the future who comes across
the problem.
In the folder where Reporting Services is installed fin a file called
ReportView.aspx
e.g.
c:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services
\ReportServer\Pages\ReportViewer.aspx
Open up this file and add the following to the Page Directive
Culture="en-AU"
This seemed to solve my problem
Regards
Rex|||On Jul 5, 10:17 pm, Markus...@.gmail.com wrote:
> On Jul 6, 10:54 am, EMartinez <emartinez...@.gmail.com> wrote:
>
> > On Jul 5, 4:50 pm, Markus...@.gmail.com wrote:
> > > Hi, we have an installation of MSSQL reporting services where users
> > > can select data based on date ranges. Since upgrading to 2005 we now
> > > have a nice new Date picker control alongside textareas which accept
> > > MSSQL datetime values.
> > > This is all very nice but the date picker automatically formats the
> > > date to US format mm/dd/yyyy. We need it to be in dd/mm/yyyy format.
> > > I
> > > have checked the regional settings of both the browser/ server etc.
> > > Scouring the Internet seems to point that this is a post SP2 problem
> > > but there seems to be no fix other than making the datefields a type
> > > of nvarchar and then converting them to dates in the Stored
> > > Procedure.
> > > If there really is no fix, how can I just disable this date picker
> > > control? In 2000 people just entered the dates manually, this was
> > > fine
> > > but know there is a date picker control people are obviously going to
> > > use it.
> > > Thanks
> > > Rex
> > Aside from the workarounds you have attempted, that is also all I can
> > think of. If I understand you correctly, to remove the date time
> > picker in a specific report you would just select the Layout view ->
> > Report drop-down tab -> Report Parameters... and select the parameter
> > you want to remove the date time picker for and then change the Data
> > type: to something other than DateTime. Hope this helps.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant- Hide quoted text -
> > - Show quoted text -
> Hi Enrique, thanks for your help. I have found a fix which seems to
> work so I'm posting here to help anyone in the future who comes across
> the problem.
> In the folder where Reporting Services is installed fin a file called
> ReportView.aspx
> e.g.
> c:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services
> \ReportServer\Pages\ReportViewer.aspx
> Open up this file and add the following to the Page Directive
> Culture="en-AU"
> This seemed to solve my problem
> Regards
> Rex
Very nice tidbit to know. So basically, that manually changed your
regional settings I guess.
Regards,
Enrique Martinez
Sr. Software Consultant