Hi, is it possible to split datetime into two columns through fetchxml?
*This post is locked for comments
Unfortunately not. Fetchxml will does not perform any transformation tasks it merely returns the data as is ready to be processed by whatever system issued the fetchxml request.
You would need to query the datetime field and then process it when the results are returned.
Hi ,
Using FetchXML you can retrieve field value as well as you can do aggregation of field . But split of a field value is not possible .
If you are executing the FetchXML in client side you can get day/month/year/time value from datetime value itself. Take a look related function to retrieve the day/month/year/time from date value.
https://www.w3schools.com/js/js_date_methods.asp
Make sure you are doing the above operation on datetime value.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Community Member 2
HR-09070029-0 2
UllrSki 2
