<html><head></head><body><div style="color:#000; background-color:#fff; font-family:verdana, helvetica, sans-serif;font-size:16px"><div id="yui_3_16_0_ym19_1_1526560349686_37802">An even easier way would be to say:</div><div id="yui_3_16_0_ym19_1_1526560349686_37802"><br></div><div id="yui_3_16_0_ym19_1_1526560349686_37802" dir="ltr">dw=dow(date field,"2")</div><div id="yui_3_16_0_ym19_1_1526560349686_37802" dir="ltr"><br></div><div id="yui_3_16_0_ym19_1_1526560349686_37802" dir="ltr">Which returns the full name of the day of the week (i.e. Sunday, Monday, etc.)</div><div id="yui_3_16_0_ym19_1_1526560349686_37802" dir="ltr"><br></div><div id="yui_3_16_0_ym19_1_1526560349686_37802" dir="ltr">Bill Lucca</div><div id="yui_3_16_0_ym19_1_1526560349686_37802" dir="ltr"><br></div> <div class="qtdSeparateBR"><br><br></div><div class="yahoo_quoted" style="display: block;"> <div style="font-family: verdana, helvetica, sans-serif; font-size: 16px;"> <div style="font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 16px;"> <div dir="ltr"><font size="2" face="Arial"> On Thursday, May 17, 2018 8:38 AM, Josh Reader via Filepro-list <filepro-list@lists.celestial.com> wrote:<br></font></div> <br><br> <div class="y_msg_container"><div dir="ltr">Hi Wayne,<br clear="none"><br clear="none">I just do something like this:<br clear="none"><br clear="none">dw=DOW(date field)<br clear="none"><br clear="none">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:<br clear="none"><br clear="none">If: dw eq "1"<br clear="none">Then: dy="Sunday"<br clear="none"><br clear="none">If: dw eq "2"<br clear="none">Then: dy="Monday"<br clear="none"><br clear="none">If: dw eq "3"<br clear="none">Then: dy="Tuesday"<br clear="none"><br clear="none">So on and so forth.<br clear="none"><br clear="none">Josh<br clear="none"><br clear="none">-----Original Message-----<br clear="none">From: Filepro-list <filepro-list-bounces+josh.reader=<a shape="rect" ymailto="mailto:mercuryelectronics.com@lists.celestial.com" href="mailto:mercuryelectronics.com@lists.celestial.com">mercuryelectronics.com@lists.celestial.com</a>> On Behalf Of Wayne Smith via Filepro-list<br clear="none">Sent: Thursday, May 17, 2018 8:18 AM<br clear="none">To: filePro Mailing List <<a shape="rect" ymailto="mailto:filepro-list@lists.celestial.com" href="mailto:filepro-list@lists.celestial.com">filepro-list@lists.celestial.com</a>><br clear="none">Subject: Day of the week<br clear="none"><br clear="none">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.<br clear="none"><br clear="none">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.<br clear="none"><br clear="none">Have merci on me fairlite, adu<br clear="none"><br clear="none">Thanks ahead of time you genius's out there.....<br clear="none"><br clear="none">--<br clear="none">Wayne Smith<br clear="none">Port Orange, Florida<br clear="none">-------------- next part --------------<br clear="none">An HTML attachment was scrubbed...<br clear="none">URL: <<a shape="rect" href="http://mailman.celestial.com/pipermail/filepro-list/attachments/20180517/099a813a/attachment.html" target="_blank">http://mailman.celestial.com/pipermail/filepro-list/attachments/20180517/099a813a/attachment.html</a>><br clear="none">_______________________________________________<br clear="none">Filepro-list mailing list<br clear="none"><a shape="rect" ymailto="mailto:Filepro-list@lists.celestial.com" href="mailto:Filepro-list@lists.celestial.com">Filepro-list@lists.celestial.com</a><br clear="none">Subscribe/Unsubscribe/Subscription Changes <a shape="rect" href="http://mailman.celestial.com/mailman/listinfo/filepro-list" target="_blank">http://mailman.celestial.com/mailman/listinfo/filepro-list</a><div class="yqt1716651979" id="yqtfd48080"><br clear="none">_______________________________________________<br clear="none">Filepro-list mailing list<br clear="none"><a shape="rect" ymailto="mailto:Filepro-list@lists.celestial.com" href="mailto:Filepro-list@lists.celestial.com">Filepro-list@lists.celestial.com</a><br clear="none">Subscribe/Unsubscribe/Subscription Changes<br clear="none"><a shape="rect" href="http://mailman.celestial.com/mailman/listinfo/filepro-list" target="_blank">http://mailman.celestial.com/mailman/listinfo/filepro-list</a><br clear="none"></div></div><br><br></div> </div> </div> </div></div></body></html>