Network Automation Software We are currently migrating this forum
over to our HelpSystems domain. Please
post all new threads in our new
HelpSystems Community Portal.
Post to the HelpSystems Forum
You are not currently logged on. You must be logged on in order to post. Log on
Or Create a new account
AutoMate Discussion
Decrease font size
Increase font size
Topic Title: Finding next day of the week
Topic Summary:
Created On: 03/13/2014 06:20 AM
Status: Read Only
Linear : Threading : Single : Branch
Search Topic Search Topic
Topic Tools Topic Tools
View similar topics View similar topics
View topic in raw text format. Print this topic.
Answer This question was answered by DavidMckittrick, on Thursday, March 13, 2014 9:53 AM

Answer:

That’s awesome! I was dabbling around for a couple hours and had something similar to what you did but just couldn't get it to work.

 

Thanks,

 

Dave.

 03/13/2014 06:20 AM
User is offline View Users Profile Print this message

Author Icon
DavidMckittrick
Student (5-19 posts)

Posts: 7
Joined: 08/14/2013

I'm importing Excel order forms and need to populate the customers delivery date.

In the Excel sheet I have a deliver date field that will have

"Mon, Tue, Wed, Thu or Fri" in it.

What I need to do is find the next date relevant to the delivery date.

So if it's Wednesday 12th and their delivery date is Tuesday. I would expect "03/18/14"

Unless it's Wednesday and their deliver day is Wednesday then it would be the current date "3/12/14"

 

I was trying to mimic some code from Excel I found but no luck.

 

=A1+7-WEEKDAY(A1+1)     (A1=Current date)



 Category Survey
AutoMate 6 version:
Windows version:
 03/13/2014 07:53 AM
User is offline View Users Profile Print this message

Author Icon
JeanDelfosse
Supreme Guru (1000+)

Posts: 8883
Joined: 03/30/2005

David,
like this ?

 Category Survey
AutoMate 6 version:
Windows version:



Task Steps: (Right click, Select All, Copy to copy to the clipboard. Steps can then be pasted into the AutoMate Task Builder)


-------------------------
Jean Delfosse - Automate Beta Tester
Win7 Pro 64 bits -Win XP Pro SP3 32 bits - AM8, AM7, BPA10, BPA9, BPA8, BPA7, AM6 Enterprise, AM4
 03/13/2014 09:53 AM
User is offline View Users Profile Print this message

Author Icon
DavidMckittrick
Student (5-19 posts)

Posts: 7
Joined: 08/14/2013

Answer Answer

That’s awesome! I was dabbling around for a couple hours and had something similar to what you did but just couldn't get it to work.

 

Thanks,

 

Dave.



 Category Survey
AutoMate 6 version:
Windows version:
 03/13/2014 11:55 AM
User is offline View Users Profile Print this message

Author Icon
JeanDelfosse
Supreme Guru (1000+)

Posts: 8883
Joined: 03/30/2005

You're welcome, Dave

 Category Survey
AutoMate 6 version:
Windows version:


-------------------------
Jean Delfosse - Automate Beta Tester
Win7 Pro 64 bits -Win XP Pro SP3 32 bits - AM8, AM7, BPA10, BPA9, BPA8, BPA7, AM6 Enterprise, AM4
Statistics
18258 users are registered to the AutoMate Discussion forum.
There are currently 0 users logged in.
The most users ever online was 6686 on 11/01/2020 at 01:24 AM.
There are currently 4219 guests browsing this forum, which makes a total of 4219 users using this forum.

FuseTalk Enterprise Edition v4.0 - © 1999-2020 FuseTalk Inc. All rights reserved.

Sitemap Network Automation Software Blog