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

OIC - How to Retrieve Email Attachments Using Microsoft Graph API: Automating Payment File Processing

Retrieving Email Attachments Using Microsoft Graph API: Automating Payment File Storage in Object Storage Use Case: A finance team needs t...