TIME & DATE FIELD NOT WORKING

Yes I most certainly do! On quit.

Great! that makes sense and I’ve done what you suggest, sorting by Time & Date and then by Latest Order and then Unspecified.

However, I’m afraid the T & D field still isn’t being filled in/populated.I’ve deleted it and re-installed it but nothing.

Don’t know if this is relevant or not but up til now I’ve entered the current date manually then, say after a month or 2 when the client orders again, I search for their record and update that field, again manually, obviously with today’s current date.

Would it be better perhaps just to use the new T & D and do without the Latest Order (Date field) all together?

Of course this would rely on me getting it to work and be populated in the first place (!).

Presumably it fills in/changes the current date each time I pull up and edit that client’s record with the details of that new order?

But if I delete the Latest Order (Date field) aren’t I going to lose the order date from all of my 2000 clients prior to making this change?

Also, I may sometimes want to simply look up something in that record and NOT change the date at all ie. there may not be a new order to add.

I’m sure there’s an easy fix to this as it must be a very common requirement in a sales database.

Thanks,

Hi Daniel, thank you for being so very prompt!
But I don’t want to change the date (for sorting reasons) if all I’ve done is look something up on the record, I only want it to change if I actually edit its details because it’s a new order.

What you’ve kindly suggested sounds to me like every time I open up a record (just to check something) its Date Modified would change too and so, say, Brendan’s name would appear at the top of my records list when he hadn’t in fact ordered anything!

I wouldn’t want to sort my records by Date Modified which brings me back to how to sort by the date and time of my latest order.

Why isn’t this field populating anyway?

Thanks and apologies if this is becoming burdensome!

OK! I get it now!

I understand the difference between DM and D&T and of course can add both and play around with them. I didn’t understand before that I had to fill in the time and ate manually – not a problem but….. trouble is I haven’t got a calendar next to my T&D field and where do I find a DM field – there isn’t one on my file?

Dear Sam and Daniel,

You’re both being so helpful but I must admit I’m getting more and more confused. I’m not an IT expert but I do use TF many times every day and couldn’t be without it for my work and I learned it myself as it’s so user friendly.

To recap….I already have a date field which populates itself and that date remains eg. 7th August, 2021, until and unless I manually change it when that client places her next order, say today, so I manually change it to 9th September, 2021.

However, and this really is such a small thing, if 10 clients place orders today, then I’d like the record list to be in chronological order rather than how I have it now which is purely alphabetical within today’s date.

I learned that there’s a Date AND TIME field which I’ve now added but it doesn’t self populate unless it’s a brand new record. If I understand correctly Daniel says it has to be done manually and that there’s a calendar icon for this (mine hasn’t got one) whilst Sam tells me it’s can’t be edited by me.

Enter Daniel’s field called Date Modified which it seems will alter every time I open that record. That’s no good for me because I may simply be looking something up, not entering a new order from my client, so I don’t want the date that’s there to change.

I don’t really need to see this date and time, I only want it to sort today’s 10 clients into chronological order. I already have, albeit manually, the date I want to keep or to update when the client orders next.

So where can I get the “Calendar” bit of the T&D field which is missing, where can I get any new fields which are not already on my files? I’ll play around with them, until I find the one which sorts my clients’ names chronologically, whether they’re new to me or old clients repeating an order?

Sorry to make this so laborious for everyone.

Wow Sam, that was the missing bit and it works perfectly and is far quicker to click “Now” than to type out the current date and exact time.

Many, many thanks.

I’ve no idea about scripts but this fixed it for me.

I’ll retain both my old Date field (using it’s calendar accessory) for historic orders and use the new T&D with it’s calendar from now on.

My Sorting is sorted too!

Great – thank you everyone!

PS is there a link to a file/doc/record which has all the possible TF fields and can it be added to my TF?

Can I download these fields and keep them somewhere on file for future use?

Presumably they come with TF but I don’t seem to have them.