Date format for from and to date fetchxml

(0) Share

Report

Posted on by Community Member

Hello Guys,

I want to fetch records based and from and to date below is my fetchxml i want to use this format ddmmyyyy rather than yyyymmdd please help

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (0)

Suggested answer

Aiden Kaskela 19,696 on at

Like (1)

Report

Hi,

I don't think you can change the format. What's the problem you're trying to get around?

Thanks,

Aiden

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

i want to use shortdate i am confused i donno much about date formats in crm

Was this reply helpful? Yes No
Aiden Kaskela 19,696 on at

Like (0)

Report

Why do you need to use the one format instead of the other? Is it just preference or is there a business need pushing you to use 'dd-mm-yyyy' ?

Was this reply helpful? Yes No
Suggested answer

Saroj Das 3,355 on at

Like (2)

Report

Follow the below steps to achieve this.

Take 4 parameters

startdate (Date Time type)

enddate (Date Time type)

startdatevalue (string) (hidden) --> set default value =Format(Parameters!startdate.Value, "yyyy-MM-dd")

enddatevalue (string) (hidden) --> set default value =Format(Parameters!enddate.Value, "yyyy-MM-dd")

<fetch mapping="logical" version="1.0" >
<entity name="hd_logmanager" >
<attribute name="hd_logmercod" alias="MerchantCode" />
<attribute name="hd_loguserid" alias="MemberCode" />
<order attribute="hd_logdattim" />
<filter>
<condition attribute="hd_logmercod" operator="eq" value="INTER09716" />
</filter>
<filter>
<condition attribute="hd_logdattim" operator="on-or-before" value="@startdatevalue" />

<condition attribute="hd_logdattim" operator="on-or-after" value=""@enddatevalue"" />
</filter>
</entity>
</fetch>

Thanks,
Saroj

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

its a business need

Was this reply helpful? Yes No
Saroj Das 3,355 on at

Like (1)

Report

The solution i have given is internally it will use the yyyy-MM-dd format to fetch the record in fetch xml but it will show the report result in dd/mm/yyyy format. The date format in your local machine should be in dd/mm/yyyy format. when you select your date range, it should be in dd/mm/yyyy format.

Thanks,

Saroj

Was this reply helpful? Yes No
Aiden Kaskela 19,696 on at

Like (1)

Report

Saroj,

Muhammed never said he's trying to write SSRS reports using Fetch - your solution may work but he hasn't given any context about how this is being used. That's what I'm trying to find out.

Aiden

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

i have a wcf service the app will send date in dd-mm-yyyy format i am using Datatype datetime for from and todate and behaviour local and my local machine format is also dd-mm-yyyy bt still when i try to send value by dd-mm-yyyy it does not return any records

localhost/.../getErrorLog;value2=2016-09-08

Was this reply helpful? Yes No