Stonefield Query
 
Stonefield Site Map
Stonefield Support

  Overview
  Submit Support Ticket
  Forums
  Online Help Files
  Services
  Pre-Sales Support
Online Webinars
Video Demonstrations
Feature Requests
  Software Maintenance
  Support Testimonials
  FAQ's
Quick Links
Buy Now!
Download Free Trial
Watch a Video
Contact Us

 
 You are here: Support * Support Forums   Search

 Stonefield Query Support Forum

Welcome to the Stonefield Query Support Forum. Please note that in order to participate in the support forums, registration at our site is required. If you are already a member of our site, please sign-in.

 

Subject: time and date

Topic is locked   

Author Messages
Buffyski
Posts:11

02/16/2007 1:37 PM Alert 
I'm working on one of my first custom reports and I need to show the contact activity detail broken down by groups.  Everything is perfect except for one thing.  I need to show the occur date and time.  The date shows fine, but the time doesn;t show up.  How can I get the date to show up?
tmansuy
Posts:166

02/16/2007 2:09 PM Alert 

Hi,

 

You can display both the date and the time components of these fields with the following steps:

1) Locate the field for which you want to display time as well as date in the "Selected fields for this report" list in step 2 of the quick report wizard

2) Select the field from the list, and click the properties button

3) On the format tab, turn off the 'use default format' and 'display date only' options. You should now see time as well when you ouput this field in a report.

 

Trevor

Buffyski
Posts:11

02/16/2007 2:18 PM Alert 
Thank you,

But I am not using the wizard, I had to use the "advanced" features to print the company name address and zip in the way way I wanted.

I don't see the options you are talking about in the properties button here.

Linda
tmansuy
Posts:166

02/16/2007 3:41 PM Alert 

Once an advanced layout is created, changing those options for a date field inside the advanced report designer is not supported. This item is currently on the list of features to add.

You should be able to change the way this Datetime is getting output with the TTOC() function. To do so, simply edit the datetime field in question, and in the output expression for this field, place the field inside a TTOC() function. So, if the field is, for example, HISTORY_START_DATE_TIME_LOCAL, the output expression would then become:

TTOC(HISTORY_START_DATE_TIME_LOCAL)

 

If this does not work, you can delete the advanced layout for the report, make the change in step 2 of the quick report wizard, and then re-create the advanced layout and re-add your custom layout changes inside the advanced report designer.

 

Trevor

Buffyski
Posts:11

02/20/2007 7:38 AM Alert 
The TTOC didn't work it made the time noon for all the dates. I deleted the advanced layout and made the change as you suggested in your first post then re-did the advanced layout.

Thank you.

Linda
Topic is locked



ActiveForums 3.6

 
 
   Privacy Statement  |  Terms Of Use
© 1996-2009 Stonefield Software Inc. All rights reserved.