Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 378
  • Last Modified:

dateformat

Hi,

How can I change the format of the date field from YYYY-MM-DD HH:MM:SS to YYYY-MM-DD.
0
minhajm
Asked:
minhajm
  • 2
  • 2
1 Solution
 
peter57rCommented:
Right-click the field and choose Format field.
0
 
minhajmAuthor Commented:
Hi,

I am using the datetime field as an input parameter and the text on the parameter window shows as "Please enter datetime format yyyy-mm-dd hh:mm:ss". I would like to display as yyyy-mm-dd.
Date.bmp
0
 
peter57rCommented:
You cannot control the appearance of parameter fields except by choosing a different datatype.

But if you are using a parameter field for selection, then it's datatype MUST match the dadatype of the database field you are comparing to.  If your database datatype is datetime then the most efficient selection will occur if the parameter is also datetime (but you will have to enter a time as well as a date).

If you want to use a Date (rather than Datetime) parameter field but your datatabase field is datetime then you would also have to create a formula field which extracted just the date from the database datetime field  for use in a selection rule.
DateValue({table.datetimefield})
This could cause the report to run slower.
0
 
minhajmAuthor Commented:
Thanks Peter I changed the parameter type to Date in the parameter edit window and it worked.
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now