SMALLJUL - connect_cdc_sqdata - Latest

Connect CDC (SQData) Apply engine

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect CDC (SQData)
Version
Latest
Language
English
Product name
Connect CDC (SQData)
Title
Connect CDC (SQData) Apply engine
Copyright
2024
First publish date
2000
Last edition
2024-07-30
Last publish date
2024-07-30T20:19:56.898694

The SMALLJUL function returns a small Julian date from the given date in YYDDD format.

Category

Date / Time

Syntax
SMALLJUL([date]) 
Parameter and Description
Parameter Description
date OPTIONAL, if no date is given then the current date is implied

Example

Determine the Julian day from the current date and map the result to target field TGT_SMALL_JULDAY. Assume that the current date is January 31st, 2000..

TGT_SMALL_JULDAT = SMALLJUL()

Returns the value of 00031 and maps the result to the target field.