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