Prev: Error Message:
Next: End of Support Date for Report Builder 1.0
From: odeddror on 10 Feb 2010 08:39
Hi there,

I'm using SSRS 2008
I have period end like 1/19/2010 field and I want to generate -5 days
(seperate textbox) from it like
1/15 1/16 1/17 1/18 1/19

I try =MyFileld.value - 1 and I got an error

How do I sbtract day fron date field?

I did also Month(myfield.value)&"/"&Day(myfield.value)-1 it works but this
is not woks allways.

Thanks

From: Uri Dimant on 10 Feb 2010 11:06
Hi Oded
> I have period end like 1/19/2010 field and I want to generate -5 days
> (seperate textbox) from it like
> 1/15 1/16 1/17 1/18 1/19

Is not that possible to do on the server side ,meaning within as SP?



"odeddror" <odeddror(a)cox.net> wrote in message
news:6A9DCD72-669F-4A13-B572-2A7A83786E83(a)microsoft.com...
> Hi there,
>
> I'm using SSRS 2008
> I have period end like 1/19/2010 field and I want to generate -5 days
> (seperate textbox) from it like
> 1/15 1/16 1/17 1/18 1/19
>
> I try =MyFileld.value - 1 and I got an error
>
> How do I sbtract day fron date field?
>
> I did also Month(myfield.value)&"/"&Day(myfield.value)-1 it works but this
> is not woks allways.
>
> Thanks


From: odeddror on 11 Feb 2010 06:42
Uri,

You are right, I'll try that even though this is a sub report, that gets his
date based on calculation.
Thats the reason why I'm asking

Thanks,
Oded




"Uri Dimant" <urid(a)iscar.co.il> wrote in message
news:OHBw6rmqKHA.6064(a)TK2MSFTNGP02.phx.gbl...
> Hi Oded
>> I have period end like 1/19/2010 field and I want to generate -5 days
>> (seperate textbox) from it like
>> 1/15 1/16 1/17 1/18 1/19
>
> Is not that possible to do on the server side ,meaning within as SP?
>
>
>
> "odeddror" <odeddror(a)cox.net> wrote in message
> news:6A9DCD72-669F-4A13-B572-2A7A83786E83(a)microsoft.com...
>> Hi there,
>>
>> I'm using SSRS 2008
>> I have period end like 1/19/2010 field and I want to generate -5 days
>> (seperate textbox) from it like
>> 1/15 1/16 1/17 1/18 1/19
>>
>> I try =MyFileld.value - 1 and I got an error
>>
>> How do I sbtract day fron date field?
>>
>> I did also Month(myfield.value)&"/"&Day(myfield.value)-1 it works but
>> this is not woks allways.
>>
>> Thanks
>
>

From: Patrice on 11 Feb 2010 08:53
Hi, try :

CDate(MyField.Value).AddDays(-4) etc...

Using CDate is likely not needed but should trigger intellisense within SSRS
allowing to see available methods...

SSRS is based on .NET so it uses the same programming model, for example :
http://msdn.microsoft.com/en-us/library/system.datetime_members.aspx for
Date(time)s

--
Patrice

"odeddror" <odeddror(a)cox.net> a �crit dans le message de groupe de
discussion : 6A9DCD72-669F-4A13-B572-2A7A83786E83(a)microsoft.com...
> Hi there,
>
> I'm using SSRS 2008
> I have period end like 1/19/2010 field and I want to generate -5 days
> (seperate textbox) from it like
> 1/15 1/16 1/17 1/18 1/19
>
> I try =MyFileld.value - 1 and I got an error
>
> How do I sbtract day fron date field?
>
> I did also Month(myfield.value)&"/"&Day(myfield.value)-1 it works but this
> is not woks allways.
>
> Thanks


 | 
Pages: 1
Prev: Error Message:
Next: End of Support Date for Report Builder 1.0