Day of the week

[WILLIAM LUCCA]

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> 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> 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>
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
Subscribe/Unsubscribe/Subscription Changes http://mailman.celestial.com/mailman/listinfo/filepro-list
_______________________________________________
Filepro-list mailing list
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/b0e1c457/attachment.html>