Wednesday, September 25, 2024

OIC - Need to format a dateTime object with a three character month

Requirement: We need to create a file name where we need to populate Month's name as MMM like Sep, Oct etc.


Solution:

fn:concat('HCM_FTE_',ns96:format-dateTime(fn:current-dateTime(),'[MNn,*-3]-[Y001]'),'.csv')

Note: for Caps month like SEP. OCT , use as [MN,*-3]

No comments:

Post a Comment

Featured Post

Microsoft Excel - Modifying an excel worksheet

Hiding and Unhiding Excel Rows and Columns Hiding Rows/Columns: Select them → Right-click → Hide . Unhiding Rows/Columns: Select nearby r...