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: Generate Datelist / dataset
Topic Summary:
Created On: 04/18/2018 05:12 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.
 04/18/2018 05:12 AM
User is offline View Users Profile Print this message

Author Icon
TimoCordes
Apprentice (20-49)

Posts: 35
Joined: 04/12/2016

Hi Guys,

I need a dataset with two different colums (startdate / enddate) with a list of start and enddates.
So for example: startdate = today + 7 days
enddate= today + 21 days
for the next x days (for example 120).
I played with date() and datediff / dateadd but didn't get there an result. It looks like that you can't use a variable with datediff/dateadd


Regards
Timo
 04/23/2018 08:03 AM
User is offline View Users Profile Print this message

Author Icon
Justin Aucoin
HelpSystems

Posts: 360
Joined: 02/15/2016

Hi Timo,

The easiest way to adjust dates is to use the Text Format Date/Time action. By default this uses the current time, but under the Advanced options it does allow you to use a time from a variable, as well as adjust the time by year, month, day, hours, minutes, and seconds.

More information on this action can be found at the link below.
https://static.helpsystems.com/automate/help/am_11/Content/TechRef/Actions_Activities/Text/Text_-_Format_date_time.htm

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

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

Author Icon
TimoCordes
Apprentice (20-49)

Posts: 35
Joined: 04/12/2016

Hi Justin, Good tip. I didn't saw that there is the possible to work with variables. Thanks
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 889 guests browsing this forum, which makes a total of 889 users using this forum.

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

Sitemap Network Automation Software Blog