The patch Code works fine, when inserting data into sql server.
It's reading the data back into the app is the issue.
The data in ActivityDate in sharepoint looks like this :
06/06/2023 11:45 am
The data in sql server looks like this:
2023-06-06 11:45:34.000
Also i created a view in sql server to make the field look like this: and changed the datasource to the view, but still did not work.
06/06/2023 11:45:34 am
here is the code: from the "data_card" object in the instruction video. "Update" property
With({lclRecs:Filter(T_NSC_TRACKCODE_TimeTracker,
Title = glbUser && StartsWith(ActivityDateTime,
Text(Today(), "[$-en-US]yyyymmdd")))},
{
CheckIn:LookUp(lclRecs, ActivityType= "Clock In", ActivityDate), <-------- NOT READING THIS LOOKUP
CheckOut:LookUp(lclRecs, ActivityType= "Clock Out", ActivityDate),
LunchOut:LookUp(lclRecs, ActivityType= "Lunch Out", ActivityDate),
LunchIn:LookUp(lclRecs, ActivityType= "Lunch In", ActivityDate),
Break1Out:LookUp(lclRecs, ActivityType= "Break1 Out", ActivityDate),
Break1In:LookUp(lclRecs, ActivityType= "Break1 In", ActivityDate),
Break2Out:LookUp(lclRecs, ActivityType= "Break2 Out", ActivityDate),
Break2In:LookUp(lclRecs, ActivityType= "Break2 In", ActivityDate)
}
)
i have tried the following:
Text(DateValue(ActivityDate,DateTimeFormat.ShortDateTime))
And
DateValue(ActivityDate,"mm/dd/yyyy hh:mm:ss a/p"))
And
Text(DateTimeValue(ActivityDate,"[$-en-US]mm/dd/yyyy hh:mm:ss"))
Thanks for replying ...Very much appreciated
Dave
