I have a field "Date" and a field "Day"
I want the "day" field to look at the "date" field and
put the correct day of the week in
How?
Thanks
Terry

Open the helpfile and look for day or date functions

Ursus

"Terry Cano" <tcmusic (AT) pacbell (DOT) net> schreef in bericht
news:GNqih.39369$qO4.10568 (AT) newssvr13 (DOT) news.prodigy.net...

I am with Ursus, but I'd add that you should try to avoid naming your fields
with the names of FileMaker functions.
Remi-Noel

"Ursus" <ursus.kirk (AT) wanadoo (DOT) nl> a écrit dans le message de news:
458a70c0$0$93183$dbd43001 (AT) news (DOT) wanadoo.nl...

Just use the same field... date. Put 2 of them on your layout and
format one date to be the day only "Thursday", and the other to the
date format you want "12/21/2006".

It's the same field, so the day shown will always be the correct
weekday.

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Reality is the leading cause of stress...
....amongst those in touch with it.
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
WinXP Pro 64Bit / FMP Adv 8.5v1
VoicesInMyHead
a.k.a. The Voices
No, we're not... Yes, we are...
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-


Terry Cano wrote:

In article <1166711744.048038.246600 (AT) 79g2000cws (DOT) googlegroups.com>,
"VoicesInMyHead" <voices.imh (AT) gmail (DOT) com> wrote:

Or even the more correct "21/12/2006". ;o)



That is the easiest way (and one often over-looked even by long-time
users), but if you actually need the day for other purposes then a
simple Calculation field will give the result.
ie.
DayforDate = DayofWeek(DateField)

Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)

Thanks -
I think I got it
Happy Holidays
Terry
"Helpful Harry" <helpful_harry (AT) nom (DOT) de.plume.com> wrote

Ok. I think Dayname is what I need is a script?
get data in "date field" put in the field named "day" and use Dayname?
Is that close
"Terry Cano" <tcmusic (AT) pacbell (DOT) net> wrote

In article <iCGih.27041$Ga1.21502 (AT) newssvr12 (DOT) news.prodigy.net>, "Terry
Cano" <tcmusic (AT) pacbell (DOT) net> wrote:

Sorry, DayName will give you the text words "Monday", "Tuesday", etc.
while DayofWeek will give you the number of the day (eg. 3 for
"Tuesday" or 6 for "Friday").

DayforDate = DayName(DateField)

Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)

Nobody mentioned script.

As Harry described, put the same date field on the layout twice.

Format one to display the date as date, format the other the display date as day name. FileMaker Help does describe how to do this quite well.

Personally, I would probably not bother with two versions. I would use just one field formatted to display both the day name and the date all in one whack, but that's just me.

Matt

On 12/21/2006 20:34:06 "Terry Cano" <tcmusic (AT) pacbell (DOT) net> wrote:

Yeah I should have thought of that to.
It is cool everything works - No Script
Thanks
To all
"Matt Wills" <Im (AT) witz (DOT) end> wrote

one whack, but that's just me.