Convert TIBCO Scribe® Online DateTime to Month and Year Only Using A Formula

Convert TIBCO Scribe® Online DateTime to Month and Year Only Using A Formula

book

Article ID: KB0078542

calendar_today

Updated On:

Products Versions
TIBCO Cloud Integration - Connect ( Scribe ) -

Description

If your source contains a DateTime field, but you want only the month and year written to your target, use the CONCATENATE and DATEPART functions in the following formula:

CONCATENATE( DATEPART( "m" , <datetime field> ) , "/", DATEPART( "yyyy" , <datetime field>))
 
For example, if the DateTime field in your source contains:

      9/3/2015  4:00:39 AM

After using the CONCATENATE and DATEPART functions in the formula shown above, the following is written to your target:

      9/2015

For additional information, see the following in the TIBCO Scribe® Online Help:
 

Issue/Introduction

Use functions in a formula to convert a Date Time field.
Powered by Wolken Software