Day of the week

[Josh Reader]

I see that now in the help, that is definitely better than my solution.  Also using “1” instead of “2” will give the abbreviated day of the week.  I will be using that moving forward when needed.

Thanks Bill

Josh

From: WILLIAM LUCCA <wlucca at prodigy.net>
Sent: Thursday, May 17, 2018 8:44 AM
To: Josh Reader <josh.reader at mercuryelectronics.com>; filepro-list at lists.celestial.com
Subject: Re: Day of the week

An even easier way would be to say:

dw=dow(date field,"2")

Which returns the full name of the day of the week (i.e. Sunday, Monday, etc.)

Bill Lucca


On Thursday, May 17, 2018 8:38 AM, Josh Reader via Filepro-list <filepro-list at lists.celestial.com<mailto:filepro-list at lists.celestial.com>> wrote:

Hi Wayne,

I just do something like this:

dw=DOW(date field)

That returns a number with number 1 being Sunday, 2 is Monday, 3 is Tuesday, etc.  Then have lines of code for each of those numbers to assign the day.  For instance:

If:  dw eq "1"
Then: dy="Sunday"

If: dw eq "2"
Then:  dy="Monday"

If: dw eq "3"
Then: dy="Tuesday"

So on and so forth.

Josh

-----Original Message-----
From: Filepro-list <filepro-list-bounces+josh.reader=mercuryelectronics.com at lists.celestial.com<mailto:mercuryelectronics.com at lists.celestial.com>> On Behalf Of Wayne Smith via Filepro-list
Sent: Thursday, May 17, 2018 8:18 AM
To: filePro Mailing List <filepro-list at lists.celestial.com<mailto:filepro-list at lists.celestial.com>>
Subject: Day of the week

Home from Hospital and pain med,s are dulling my otherwise sharp grasp of the power of filePro.  Some humor and help is in order.

This morning I tackled showing the DAY of the week from a 8 long mdy/ field.  Then converting same to the commonly accepted MON, TUE, Etc etc.

Have merci on me fairlite,  adu

Thanks ahead of time you genius's out there.....

--
Wayne Smith
Port Orange, Florida
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20180517/099a813a/attachment.html>
_______________________________________________
Filepro-list mailing list
Filepro-list at lists.celestial.com<mailto:Filepro-list at lists.celestial.com>
Subscribe/Unsubscribe/Subscription Changes http://mailman.celestial.com/mailman/listinfo/filepro-list

_______________________________________________
Filepro-list mailing list
Filepro-list at lists.celestial.com<mailto:Filepro-list at lists.celestial.com>
Subscribe/Unsubscribe/Subscription Changes
http://mailman.celestial.com/mailman/listinfo/filepro-list

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20180517/ccdbbe8e/attachment.html>