Link to home
Start Free TrialLog in
Avatar of gilnari
gilnariFlag for United States of America

asked on

Date Time to Date in XML value string

Need to convert a value in XML from 7/15/2017 3:48:40 PM  to 7/15/2017    The value is retrived from this statement currently in the XML Code
<Value>=Fields!ExpiryDate.Value</Value>

How can I change <Value>=Fields!ExpiryDate.Value</Value>   so only the Date is returned
Avatar of Darrell Porter
Darrell Porter
Flag of United States of America image

What tool are you using to generate the XML?
Avatar of gilnari

ASKER

<?xml version="1.0" encoding="utf-8"?> <Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition" xmlns:rd=" http://schemas.microsoft.com/SQLServer/reporting/reportdesigner"> <DataSources>

Does this help.  It is used to print a Zebra Label.
ASKER CERTIFIED SOLUTION
Avatar of Shaun Vermaak
Shaun Vermaak
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial