Share
ReportHi, is it possible to split datetime into two columns through fetchxml?
*This post is locked for comments
You’re offline. This is a read only version of the page.
2,397
Hi, is it possible to split datetime into two columns through fetchxml?
*This post is locked for comments
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.
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (