The Weird and The Wonderful

   

The Weird and The Wonderful forum is a place to post Coding Horrors, Worst Practices, and the occasional flash of brilliance.

We all come across code that simply boggles the mind. Lazy kludges, embarrassing mistakes, horrid workarounds and developers just not quite getting it. And then somedays we come across - or write - the truly sublime.

Post your Best, your worst, and your most interesting. But please - no programming questions . This forum is purely for amusement and discussions on code snippets. All actual programming questions will be removed.

View All Threads First Prev Next

How to conver Date to yyyyMMdd format in SSRS virang_218-Nov-12 14:41 virang_21 8-Nov-12 14:41  In few of the reports I came across this while doing some maintenance work... beautiful isn't it ??? VB select ...... where and F2TRDT >= " & Year(Parameters!DateFrom.Value)*10000+Month(Parameters!DateFrom.Value)*100+day(Parameters!DateFrom.Value) & " and F2TRDT <= " & Year(Parameters!DateTo.Value)*10000+Month(Parameters!DateTo.Value)*100+day(Parameters!DateTo.Value) & " Zen and the art of software maintenance : rm -rf * Math is like love : a simple idea but it can get complicated. Re: How to conver Date to yyyyMMdd format in SSRS csharpbd8-Nov-12 21:40 csharpbd 8-Nov-12 21:40  Nice thinking! Re: How to conver Date to yyyyMMdd format in SSRS Bernhard Hiller9-Nov-12 1:20 Bernhard Hiller 9-Nov-12 1:20  Oh, I see your point: that guy was assuming a month could have upto 99 days, and a year upto 99 months, and thus was waisting many numbers, and his formula will soon hit the limits of an Int32. He'd better do a SQL and F2TRDT >= " & Year(Parameters!DateFrom.Value)*372+Month(Parameters!DateFrom.Value)*31+day(Parameters!DateFrom.Value) & " and F2TRDT <= " & Year(Parameters!DateTo.Value)*372+Month(Parameters!DateTo.Value)*31+day(Parameters!DateTo.Value) & " which still waists some 6 or 7 days per year. Re: How to conver Date to yyyyMMdd format in SSRS virang_2110-Nov-12 10:51 virang_21 10-Nov-12 10:51  It is not about converting into integer number... The date needs to be in yyyyMMdd format.. The whole point is why not use Foramt() function... Zen and the art of software maintenance : rm -rf * Math is like love : a simple idea but it can get complicated. Re: How to conver Date to yyyyMMdd format in SSRS Bernhard Hiller10-Nov-12 21:45 Bernhard Hiller 10-Nov-12 21:45  ... I'd better have marked my post as a joke ... Re: How to conver Date to yyyyMMdd format in SSRS _Damian S_12-Nov-12 14:17 _Damian S_ 12-Nov-12 14:17  virang_21 wrote: The whole point is why not use Foramt() function... Is that similar to the Format() function? Silence is golden... but duct tape is silver!! Booger Mobile - My bright green 1964 Ford Falcon - check out the blog here!! | If you feel generous - make a donation to Camp Quality!! Re: How to conver Date to yyyyMMdd format in SSRS Sentenryu12-Nov-12 4:48 Sentenryu 12-Nov-12 4:48  now i need some mind bleach, thanks. I'm brazilian and english (well, human languages in general) aren't my best skill, so, sorry by my english. (if you want we can speak in C# or VB.Net =p)

Last Visit: 31-Dec-99 18:00     Last Update: 25-Apr-24 17:44 Refresh 1

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.