I have an external BAQ that I am using in a function to update a UD table. I can see in the BAQ and an output file from the function that the dates are correct but when I look at the UD table it is set to today’s date. Is there a way to properly format the date so it isn’t set to today? Here’s my …

What system file do I need to including in the Using statements to get this to work? I get a compiler error. None of the Parse statements has worked yet.

Thats my bad. Try: jpDate.ToString(“o”); or string customIsoString = jpDate.ToString(“yyyy-MM-ddTHH:mm:ssK”); Those should be base included

What sql editor are you using? might need to tweak a setting to get the right output to show as you want it. What is the desired output?

I have tried just about every combination suggested for this. I tweaked my code to do a TryParse and see what happens. In my output log file I see this: Good Date 9/17/2025 6:51:04 PM found 0 rows after if job/date not found POC-0001050 date written 9/17/2025 6:51:04 PM Indicating the date wa…

Make sure your writeline is outputting exactly what is being set, not parsing it or anything. Write now with that last one, strDateSet is definitely not in the correct format to update a date. You should expect writeline to show something like “Date01”: “2026-06-16T19:33:10.982Z”

For example, and I just tested this out to make sure. I took a UD table entry and using UpdateExt { “ds”: { “UD33”: [ { “Company”: “YOURCOMPANY”, “Key1”: “1”, “Key2”: “”, “Key3”: “”, “Key4”: “”, “Key5”: “”, “Date01”: “2026-06-11T19:06:57.901Z”, “SysRowID”: “YOUR SYSROWID”, “BitFlag”: 0, “RowMod”:…

I am working in a function. At the bottom of my code is a DB.SaveChanges statement so I don’t think it is necessarily acting the same.

Can you post the entire function? Or at least more than the little snippet?

Here is the code. DataTable dtJP; DataSet dsJP; string jpJobNum = ""; string jpName = ""; int jpOper = 0; string jpResource = ""; DateTime jpDate; string strProject = ""; string strReason = ""; string strReasonCode = ""; string strDateSet = ""; string path = @"\\myserver.com\EpicorD…

Sorry, I see how you are using it now, and you dont have to parse it to string for it to work correctly. After the last line in the for, ud33Svc.Update(ref ds33); do a get by ID to get the now updated row, then print the date from there. I think at the bottom when you do Db.SaveChanges, you are r…

Proper way to format a date in a function

Epicor ERP 10

timshuwy (Tim Shoemaker) June 17, 2026, 12:15am 19

You might check out the new post I created about: Dates, Times, DateTimes, SQL, LINQ, and the Usual Confusion which might become the “authority” on the subject in the future

Topic		Replies	Views
Date a day off Kinetic ERP e10 , bpm , customization , baq , dashboard , ubaq	22	2234	March 15, 2024
No overload for method 'ToString' Epicor ERP 10 bpm	9	2412	November 15, 2022
Epicor Date data type in C# Epicor ERP 10	8	6257	September 5, 2017
Updatable BAQ for UDtable, Force today date/time to Date01 Epicor ERP 10 baq	7	1236	May 11, 2022
Trouble getting a UD110A table to update a column Epicor ERP 10 customization	8	936	November 24, 2021

Proper way to format a date in a function

Related topics