Hello All,
I have created an application where user can create an excel template using Export CDT to excel smart service and upload the same after adding associated data to it. Basically the excel file includes list of labels and user can add values for each label on a row basis. After user uploads the data I'm checking for some validation and based on that the final values is being displayed on a grid. The problem happening here is related to the date field information added by the user. There are 4 date fields and user can enter date information in a standard format i.e YYYY-MM-DDTHH:MM:SS. While displaying this information after converting the date into proper format using datetime() function, The first date column shows different values compare to other. To elaborate further please go through the below example
Suppose my excel sheet is something like below
TargetDate TargetAtRisk SLADate SLAATRisk
2018-05-13T04:00:00 2018-05-13T04:00:00 2018-05-13T04:00:00 2018-05-13T04:00:00
Where below two columns shows the data. Now when I create a grid the values it shows are
5/13/2018 8:00 AM GTM+00:00 5/13/2018 4:00 AM EDT 5/13/2018 4:00 AM EDT 5/13/2018 4:00 AM EDT
5/13/2018 4:00 AM EDT 5/13/2018 4:00 AM EDT 5/13/2018 4:00 AM EDT 5/13/2018 4:00 AM EDT
So, As you can see the value at first row first column for Target Date is different from others. Also the value at second row first column is for TargetDate but its showing fine there. Can someone please help me to understand the possible cause behind this?
Discussion posts and replies are publicly visible
Hi vivek, did you solve the issue?
If not,
While parsing your date from excel to cdt, try useing a userdatetime() function.