Add a specified number of days to a date, passing weekends and holidays

[newbiecoder]

I'm not able to upload anything for some reason, even after zipping the file. I may have to list out the fields i'm using.

[Gicu]

Does it give you an error or what is happening. The process to upload is somehow convoluted but I haven't had any problems. If stuck you can try emailing it to me as a zip file at info@forestbyte.com

Cheers,
Vlad

[newbiecoder]

It comes back with an error stating: CorrectionsDatabase.zip failed to upload. Unfortunately, I can not email externally.

[newbiecoder]

It comes back with an error stating: CorrectionsDatabase.zip failed to upload. Unfortunately, I can not email externally.

I have the correct time located in the initial due date and time (including dates that fall on the weekend). Is there a way I can extract the time from that date/time value and add it to the date that your query provides

[Gicu]

Try to use the TimeValue function to get the time TimeValue([OriginalDueDate]) (or simply [OriginalDueDate] - Int([OriginalDueDate])) and add it to the column returning the day in the query (DUE_DATE_WITH_TIME: [DUE_DATE] +TimeValue([OriginalDueDate])) .

I think your bigger issue is with the DAYS_REMAINING which are now static, so will be outdated soonest after you update them in the table. Try to use the calculated fields instead in the query.

Cheers,
Vlad

[newbiecoder]

I tried using TimeValue([OriginalDueDate]) but it pulled in 12AM for every record

[Gicu]

Are you sure you have the time part in that field ([OriginalDueDate] - this is the name I came up with, what is the name in yours)?