Re: File number formatting question

2018-06-12 Thread Tom Dillon via 4DBasics
tring(Year of($test date))+String(Month of($test date))+"0"+String(Day of($test date)) Else //Month and Day both greater than 9 $date_text:=String(Year of($test date))+String(Month of($test date))+String(Day of($test date)) End case ALERT("value = "+$date_text) On Mon

Re: File number formatting question

2018-06-11 Thread Tom Dillon via 4DBasics
Your probably don't need an answer anymore but just in case here is how I would handle it. I forgot about the time part but you can add that in. TRACE $test date:=Date(Request("enter test date")) Case of : (Day of($test date)<10) & (Month of($test date)<10)) $date_text:=String(Year of($TEST

Re: File number formatting question

2018-05-29 Thread Tom Dillon via 4DBasics
I can help you later today. Easy fix. On Tue, May 29, 2018 at 9:11 AM Stephane Potvin via 4DBasics < 4dbasics@lists.4d.com> wrote: > Hello all, > > I am using 4D 13.5 > > I am building a database to keep track of music being performed at church > every Sunday. > > To identify each service I

Re: Printing an audit report

2018-04-30 Thread Tom Dillon via 4DBasics
I can help you but I would need a better understanding of what you are actually trying to do. Can you send me a sample of what the report should look like and what are the tables etc. On Mon, Apr 30, 2018 at 2:38 PM Noah via 4DBasics <4dbasics@lists.4d.com> wrote: > Good afternoon! > I am adding

Re: Looking for 4D developer to help with in-house database expansion

2018-07-26 Thread Tom Dillon via 4DBasics
we have a phone chat to see if there is a fit. I would like to view your database structure which would give me a good idea on what I would be dealing with. I am also only up to Version 13 so if latest version is required than I would expect that cost to be yours. Regards, Tom Dillon On Wed

Re: Modified record date (4D V16R6)

2018-03-28 Thread Tom Dillon via 4DBasics
If I understand it correctly I would simple do this. if([tabel]orig_date=!00/00/00!)`This is a new record [tabel]orig_date:=current date v_date:=current date else v_date:=current date end if On Wed, Mar 28, 2018 at 2:37 PM, Larry Russell via 4DBasics < 4dbasics@lists.4d.com> wrote: >