| Author |
Message |
jbattelle
Newbie
Joined: 06 Feb 2012
Location: United States
Online Status: Offline
Posts: 25
|
   Posted: 14 Jan 2013 at 11:45am |
|
Hey I know its 3 years later, but I saw your post, and I am having the same error when I paste it. What did you change to fix it? Thanks
|
 IP Logged |
|
jwilliams
Newbie
Joined: 23 Nov 2013
Online Status: Offline
Posts: 12
|
Posted: 15 Jan 2014 at 3:11am |
Hi Seabass,
What did you do to fix the syntax error? I can't figure it out.
Thanks for any help.
Jen
|
|
IP Logged |
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
Posted: 15 Jan 2014 at 4:15am |
NumberVar YearPart;
NumberVar MonthPart;
NumberVar DayPart;
WhilePrintingRecords;
YearPart := tonumber({data_date_field} [1 To 4]);
MonthPart := tonumber({data_date_field} [5 To 6]);
DayPart := tonumber({data_date_field} [7 To 8]);
Date (YearPart,MonthPart,DayPart)
|
|
IP Logged |
|
jwilliams
Newbie
Joined: 23 Nov 2013
Online Status: Offline
Posts: 12
|
Posted: 15 Jan 2014 at 4:22am |
Thank you for the quick response.
I get an error of The string is non-numeric on the YearPart:= tonumber
|
|
IP Logged |
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
Posted: 15 Jan 2014 at 4:25am |
is the field you are converting from a string or a numeric field type?
Edited by DBlank - 15 Jan 2014 at 4:25am
|
|
IP Logged |
|
jwilliams
Newbie
Joined: 23 Nov 2013
Online Status: Offline
Posts: 12
|
Posted: 15 Jan 2014 at 4:48am |
It's actually showing as a memo fiield.
Example of what my view is:
1/2/2014 called and prescriber is Brock called office to see if they will RX for pt and phone line is busy, will try again.. Leann Williams LPN
> From: Schall
> To: Williams, Leann M
> Sent: 1/2/2014 10:38 AM
>
who has been Rx'ing this?????
> From: Williams, Leann M
> To: Schall
> Sent: 1/2/2014 9:08 AM
>
1/2/2014 called Fayette Pharm and they stated that Metanx tablets are a supplement for kidney health .. Leann Williams LPN
> From: Schall
> To: Team, Orange
> Sent: 12/30/2013 5:44 PM
>
I am not sure what this is???????
> From: Williams, Leann M
> To: Schall
> Sent: 12/30/2013 4:19 PM
>
12/30/2013 Fayette Pharmacy requesting...Metanx Tablet PAM, taking 1 capsule PO BID, #60, refills 12.. Leann Williams LPN
Edited by jwilliams - 15 Jan 2014 at 4:49am
|
|
IP Logged |
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
Posted: 15 Jan 2014 at 5:01am |
what do you want to do with the memo field?
I assume do something with one of the date strings imbedded in it but this had a lot of dates in it and they are strewn through out it.
|
|
IP Logged |
|
jwilliams
Newbie
Joined: 23 Nov 2013
Online Status: Offline
Posts: 12
|
Posted: 15 Jan 2014 at 5:05am |
I need the minimum date. I know there are a lot of dates.
What I'm experiencing right now is when I tell the system to only show the last 5 days, it is searching the memo field and pulling in that record even if the message wasn't created in the last 5 days. The message could have been created 2 weeks ago but had a response in the last 5 days.
I've tried creating a minimum but I get the same results.
Thanks so much for any guidance. 
|
|
IP Logged |
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
Posted: 15 Jan 2014 at 5:19am |
this appears to be a string(memo) that is appended in descending order from newest to oldest with a standard format of:
> From: lname, fname mi
> To: name
> Sent: MM/dd/yyyy h:mm PM
>
typed in text
You would like to see anything that that has the most recent Sent date in the last 5 days.
Is that accurate?
If not please explain what is inaccurate and what you would chnage to make the statement accurate.
|
|
IP Logged |
|
jwilliams
Newbie
Joined: 23 Nov 2013
Online Status: Offline
Posts: 12
|
Posted: 15 Jan 2014 at 5:23am |
I need to see oldest date or date of creation. When the message originated. If the origination date doesn't fall in the 5 day window then I don't want to see it.
Sorry for the confusion.
|
|
IP Logged |
|
|
|
