Two questions:
1) I want to display date in a date parameter field as 'YYYY-MMM-DD' format i.e '2007-JAN-20' .But its not letting it convert to desired format.As soon as i type this date in default value of parameter,it changed it to 2007-01-20.Any ideas?
2) Another question regarding writing professional reports.If report needs a parameter,it should be implemented through parameters inside the Add Command window or through defining parameter in field explorer and use this parameter in record selection window?1) Give this a try replacing "currentdate" with you parameter...
ToText(Year(CurrentDate),"####") & "-" & MonthName (Month (CurrentDate),True) & "-" & ToText(Day(CurrentDate),0)
2)This depends on how the parameter is used... Is the parameter used in the initial selection of the records in the dataset or to filter records that have already been returned to the report?|||Thats what my question is :
For initial query where i want to select records based on some parameter,should i give the condition in Add command window or i select all records then filter them using select record?
if not so,then why we use select record window?|||There's no right or wrong answer to your question. You can do it either way.
Tuesday, February 14, 2012
Display date as YYYY-MMM-DD format
Labels:
2007-jan-20,
database,
date,
display,
field,
format,
microsoft,
mysql,
oracle,
parameter,
questions1,
server,
sql,
yyyy-mmm-dd
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment