Comparing 2 date fields with different format

Question

Hi All, My requirement is as below Background : Asset shared date is custom form field entered by users manually on demand issue created. Since the demand ticket (issue ) should be created in advance or on the same date when assets were shared For hygiene check we wish to check if any demand ticket created has asset shared date before demand entry date. Demand entry date is a general entry i.e system generated value in DD/MM/yy hr:min:ss format now when I use the below filter DE:asset_shared_date=FIELD:entryDate DE:asset_shared_date_Mod=lt I get all those entry which has same asset shared date and demand entry date - this is because entryDate is with time stamp and asset shared date is just mm/dd//yyyy format. How can I use only DD_MM_YY part of entrydate to compare it with asset shared date ? Subhash Sargar Mobile +91-9930042726 Aspiring to be Workfront expert

NicholeVargas · Answer

@Subhash Sargar In order to have the Entry Date field show as simply a DD-MM-YY field, you would need to create a new custom form, or edit an existing issue custom form, and add the calculated field with the expression, CLEARTIME(Entry Date). Make sure that custom form is associated with all issues in your system. Then, when you apply the filter for comparison, use this custom field. Additional calculated data expressions can be found in the article, https://experience.workfront.com/s/article/Calculated-data-expressions-679086747 Nichole Vargas Customer Programs Specialist, Workfront

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded