Search found 4 matches
- Tue Jul 07, 2015 6:27 pm
- Forum: Issues
- Topic: Return record closest to today's date
- Replies: 3
- Views: 122
- Jump to post
Return record closest to today's date
Thank you. I did see this about sorting, but will it not still return every record for a single client? Albeit just in a sorted order? I only want one record back of the several there will be. That's why I was thinking of some sort of 'find next record less than or equal to [today]'. Something along...
- Tue Jul 07, 2015 4:55 pm
- Forum: Issues
- Topic: Return record closest to today's date
- Replies: 3
- Views: 122
- Jump to post
Return record closest to today's date
I am able to populate a text field with today's date, how can I use that (or store it to a variable?) to query records to return only the record that is closest to today's date? Each client will have dozens of records, and I only want to return the latest of them when picked.
- Tue Jun 23, 2015 9:54 pm
- Forum: Issues
- Topic: Storage variable query
- Replies: 2
- Views: 108
- Jump to post
Storage variable query
Thank you. I did read that documentation, and got a working REST service setup for login, but that variable was throwing me off for this task. That second link might do the trick.
- Tue Jun 23, 2015 2:34 pm
- Forum: Issues
- Topic: Storage variable query
- Replies: 2
- Views: 108
- Jump to post
Storage variable query
I'm new to app development, and more familiar with SQL. But, basically, I have a user sign in, and they'll see clients assigned to them. Then they pick a client from that list, and I need to send that client name through a query of all of their clients to pull the last visit. I stored the client nam...