Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2015
    Posts
    8

    Answered: Query productivity report showing only updated

    I'm trying to make a query to show only what has been updated on Current date, Like a productivity Report.
    Using this [$_updated_dt] - date and time of the record update.

    I'm using it as text formula.

    Formula: [$_updated_dt]
    Rule to use: =
    Compare with: Text Formula
    Text Formula: [$_date][$_time]

    So it is like: [$_updated_dt] = "[$_date][$_time]".

    But the query shows no records.

    I know I must be doing something wrong but cannot seem to find it.
    Any sugestions?

    Thanks,

    Angelo

  2. Best Answer
    Posted by Tubbritt

    "
    I'm trying to make a query to show only what has been updated on Current date
    Every single field on your form should “On Edit” change a date field to "current date". Lets call the date field, “last edit” for example. It's the date in the “last edit” field you need to have the query search for.

    The “On Edit” part to all this simply records the last time the record was modified. The way you have it written right now doesn't look like it would ever work to me. I don't see how your using a variable to = a date and time. The first variable is not going to remember the last edit date of every record. Depending on how you have it written, the most it will remember is one record.

    Regards
    James"


  3. #2
    Join Date
    Apr 2013
    Location
    USA
    Posts
    132
    Provided Answers: 2
    Your problem may be the time. Remove the time from your query.

    Make sure that you have entries for today so your query will pickup only today entries.

  4. #3
    Join Date
    Jul 2012
    Location
    Ireland
    Posts
    815
    Provided Answers: 17
    I'm trying to make a query to show only what has been updated on Current date
    Every single field on your form should “On Edit” change a date field to "current date". Lets call the date field, “last edit” for example. It's the date in the “last edit” field you need to have the query search for.

    The “On Edit” part to all this simply records the last time the record was modified. The way you have it written right now doesn't look like it would ever work to me. I don't see how your using a variable to = a date and time. The first variable is not going to remember the last edit date of every record. Depending on how you have it written, the most it will remember is one record.

    Regards
    James

  5. #4
    Join Date
    Feb 2015
    Posts
    8
    James,

    Sorry for the late reply,
    I thought I replied already and received a message that it will be moderated by an admin, but that message was never published.

    So here is what I've done as you suggested.

    I've added a field for date only and added also a script to update that field on click with current date.

    Thank you very much.

    Angelo

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •