Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Development Tools
 Reporting Services Development
 Format Date/Time to Date

Author  Topic 

huynhtl
Posting Yak Master

107 Posts

Posted - 2008-08-14 : 15:45:02
Hi
Is there a way to format this (Globals!ExecutionTime is in expression under globals on left) from the system to just date instead of date/time?

i.e.
8/17/2008 12:25:15 PM

i want
8/17/2008

cardgunner

326 Posts

Posted - 2008-08-14 : 15:55:24
=format(Globals!ExecutionTime, "d")

CardGunner
Go to Top of Page

huynhtl
Posting Yak Master

107 Posts

Posted - 2008-08-14 : 16:05:55
Thanks!!!!!!!!!!!!
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-08-15 : 01:32:22
you could simply right click on cell and select properties. Go to format tab and select reqd date format from there also.
Go to Top of Page
   

- Advertisement -