Hi @Damodaran ,

I’d use a either a web client script or a sql view to perform this operation.

1)Simply you can write a sql view to get the date, month and year with functions like cast, convert, dateadd and then apply this view to FSM by making primary table key relationships. I hope you’re already aware about how to incorporate views with fsm.

2)Other way will be to split the datetime with a web client script using stringSplit function. Please check the sample script given below

var planEnd=getControlValue('task','plan_end_dttm'); //Get the control value
planEnd=stringSplit(planEnd,'T'); //split the datetime value from 'T' (this will separate the time aside)
var planEndDate=stringSplit(planEnd(0], '-'); // get the first element from the above result and split the date by '-' character

var planEndYear=planEndDatea0]; //Get year
var planEndMonth=planEndDatel1]; // Get month
var planEndDay = planEndDatep2]; // Get day

//then set the results for the userdefs mentioned above

Hey @Damodaran 

You did not provide too much details. 

But there is an option to do it with a client script.

For example:

var planStartDttm=getControlValue('task','plan_start_dttm');
planStartDttmArr=stringSplit(planStartDttm,'T');
var planStartDateArr=stringSplit(planStartDttmArrr0],'-');
var planStartDay=planStartDateArrr2];
var planStartMonth=planStartDateArrr1];
var planStartYear=planStartDateArrr0];

setControlValue('task','user_def17',planStartDay);
setControlValue('task','user_def18',planStartMonth);
setControlValue('task','user_def19',planStartYear);

Demo

If you provide more details on the business requirements, maybe we can suggest another/better solution?!

Please note, you might need to take care of timezone differences, depends on your use cases and environment settings.

Cheers!

@Saranga Amaraweera Thanks . i think first option will work for us