Platform

Platform

A place for Apptio product users to learn, connect, share and grow together.

 View Only

Use date variables in Datalink SQL connectors (Outdated, click for updated version) 

Thu June 30, 2016 03:33 PM

This content has been updated and can be viewed in the DataLink Connector Guides. 


#Datalink

Statistics
0 Favorited
0 Views
0 Files
0 Shares
0 Downloads

Comments

Thu October 13, 2016 01:30 PM

Whew, glad it worked. I did confirm with our engineers that {dd} is not currently supported.


#Datalink

Thu October 13, 2016 01:09 PM

Date functions work. Thanks.


#Datalink

Wed October 12, 2016 08:42 PM

Hi Tony, I'm going to say "no" to the first one and suggest that there's probably a way to use SQL date functions to get what you want. Similarly, I believe there's a way to use string functions on the Datestring variable to create the offset you're after.

 

If I'm missing the point on the use case, please let me know.


#Datalink

Wed October 12, 2016 04:33 PM

Two questions: is there a day variable such as {dd} and is there a way to increment, such as {MM}+1?


#Datalink