The 'FirstValidBefore' function is not visible inside the function list in TIBCO Spotfire Analyst

The 'FirstValidBefore' function is not visible inside the function list in TIBCO Spotfire Analyst

book

Article ID: KB0076453

calendar_today

Updated On:

Products Versions
Spotfire Analyst 7.11.x and above

Description

 The 'FirstValidBefore' function is not visible inside the function list of the calculated column/Custom expression window but if you use it by manually typing it then it works fine. 

Issue/Introduction

The 'FirstValidBefore' function is not visible inside the function list inside Spotfire client.

Environment

All Supported OS

Resolution

 To avoid any older analysis file(s) from breaking or getting invalid by renaming of function, we kept 'FirstValidBefore' hidden and don't promote it in the user interface(UI). Below is the reference image which actually explains the working method of 'LastValidBefore' function: User-added image