Simple Date Formatting Questions

Question

Hello all,

Need some help formatting a date..  Simple but I am not sure of how to do expressions in SQL report service, new to the product.

So here it is..   In my expression box I have =Fields!ServiceDt.Value   this returns mm/dd/yyyy HH:mm:SS  I want it to return YYYYMM  any help would be great.  Just need to know the code for the expression box!! Help!  Thanks everyone, you guys are always great help

Answer 1

Hey George

Thats a simple one :).

Here you go:

=Format(Today(), "yyyyMM")

All you have to do is replace Today() with your field so it becomes

=Format(Fields!ServiceDt.Value, "yyyyMM")

Visit http://jhermiz.googlepages.com/sqlbooks for great Reporting Services books

Site http://jhermiz.googlepages.com

Answer 2

Also for anyone else here's an article on setting default dates in reporting services:

http://jhermiz.googlepages.com/defaultdatemsrs

Answer 3

thank you for the help and the resource!