sql server reporting services: @TimeStamp on file delivery -- sql server reporting services

@TimeStamp on file delivery

SA
4/13/2007 1:22:07 PM

sql server reporting services:

Hi guru,

I am running into a problem where I have no solution. I have created weekly
SQL subscription and choose delivery method to File Share which is working
fine. My manager wants to have date on each published file. I have found on
MSDN that I could use @Timestamp variable at the end of file name that will
insert the time but the problem is the format. The timestamp is inserted in
Year_Min_Date_random numbers. It is not inserting month. e.g I published one
report today at 2:05 the time stamp was 2007_05_13_120552. I don;t know why
it is inserting min not months. Is it a bug or is there any solution to that.

I appreciate your help

Thanks

Re: @TimeStamp on file delivery

Lisa Slater Nicholls
4/15/2007 5:13:54 PM

That's strange...

I just tried it and got

Test2007_04_15_170209.xml

.... which is correct.

What is the locale (regional information) for the computer that is running
Reporting Services? Anything in the way the regional formats are being
applied to date and times that might explain this?

If you open a table in the ReportServer database using Management Studio and
look at the contents of a date column in a table (say, ModifiedDate in the
Catalog table), do the contents look correct to you?

And, this is probably a completely stupid possibility but... any chance the
server itself has the WRONG date and time set?

[quoted text, click to view]

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.