Network Automation Software
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: Need help using Format()
Topic Summary:
Created On: 04/04/2017 06:37 PM
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.
 04/04/2017 06:37 PM
User is offline View Users Profile Print this message

Author Icon
ConTrelos
Apprentice (20-49)

Posts: 44
Joined: 09/01/2013

What I am trying to do :

Open up an Excel Worksheet.

Get the data value from the first cell

Convert the String into a Date value that Automate will recognize

Format the date value to dd/mm/yyyy

Add +1 days to that value.


I had a look online for the solution, and this is what I have come up with, but the Format(ExcelDate, +1, 'dd/mm/yyyy') doesn't work.

What did I do wrong ?

 

 



 Category Survey
AutoMate 9 version: 9.0.5
Windows version: Windows 7



Task Steps: (Right click, Select All, Copy to copy to the clipboard. Steps can then be pasted into the AutoMate Task Builder)
 04/05/2017 01:02 PM
User is offline View Users Profile Print this message

Author Icon
Ricardo Castaneda
HelpSystems

Posts: 3424
Joined: 01/11/2008

Hello,

Would it be possible to provide a sample excel file as well?

 Category Survey


-------------------------

Ricardo Castaneda | Principal Support Analyst
AutoMate | Division of HelpSystems
HelpSystems, LLC | T: +1.213.738.1700
 04/05/2017 05:23 PM
User is offline View Users Profile Print this message

Author Icon
ConTrelos
Apprentice (20-49)

Posts: 44
Joined: 09/01/2013

Just make a blank Excel file and put a date in cell A1

 



 Category Survey
AutoMate 9 version: 9.0.5
Windows version: Windows 7
 04/06/2017 09:49 AM
User is offline View Users Profile Print this message

Author Icon
Justin Aucoin
HelpSystems

Posts: 360
Joined: 02/15/2016

Hi ConTrelos,

You will want to use the DateAdd function, as shown in the step below.

 Category Survey
AutoMate 9 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)


-------------------------

Justin Aucoin | Support Analyst
AutoMate | Division of HelpSystems
HelpSystems, LLC | T: +1.213.738.1700 | F: +1.213.738.7665
 04/07/2017 03:39 AM
User is offline View Users Profile Print this message

Author Icon
ConTrelos
Apprentice (20-49)

Posts: 44
Joined: 09/01/2013

Thank You for that



 Category Survey
AutoMate 9 version: 9.0.5
Windows version: Windows 7
Statistics
18257 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 445 guests browsing this forum, which makes a total of 445 users using this forum.

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

Sitemap Network Automation Software Blog