Thursday, February 09, 2012  | 
Welcome to Module Masters support forums - the primary support mechanism for our products. Feel free to post your questions, and we will aim to respond in a timely manner.  We also encourage our users to post any feedback you may have.  You may also email us directly at service@modulemasters.com
Subject: Date foramt
Prev Next
You are not authorized to post a reply.

Author Messages
muniappanUser is Offline

Posts:53

11/06/2007 11:53  

I want to show the date in mm/dd/yy date format. In the formatdatetime function I can only specify the long date / Short date. If I am specifying short date it is taking from the system regional settings [In the regional settings it is specified as mm/dd/yyyy]. I want to show mm/dd/yy only to this report and mm/dd/yyyy to other reports. Can you please let me know how to do this?

Thanks

muniappanUser is Offline

Posts:53

11/06/2007 13:38  
I got the answer. I have to use the following,

Format(Fields!YourDateField.Value,"MM/dd/yy")
hostUser is Offline

Posts:497

11/20/2007 19:50  
You got it!
You are not authorized to post a reply.



ActiveForums 3.7
Copyright 2011 by Module Masters Privacy StatementTerms Of Use