Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Change Date Format Expand / Collapse
Author
Message
Posted Wednesday, January 22, 2014 3:26 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, September 22, 2014 4:19 AM
Points: 50, Visits: 303
Hi,

When I use expression ="Report Generation Date: " & Today()
I get date as 1/22/1013. How can I change it to 22/1/2013?

Thanks for the help.
Post #1533528
Posted Wednesday, January 22, 2014 3:29 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Sunday, October 19, 2014 2:53 AM
Points: 3,133, Visits: 3,402
Bad Post - deleted

-------------------------------
Posting Data Etiquette - Jeff Moden
Smart way to ask a question

There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
Post #1533530
Posted Wednesday, January 22, 2014 6:39 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 6:01 AM
Points: 6,954, Visits: 7,077
Change the report language to en-GB
or
Change the expression to
String.Format("Report Generation Date: {0:dd/MM/yyyy}",Today)



Far away is close at hand in the images of elsewhere.

Anon.

Post #1533593
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse