Are you having problems with every date that goes over a year? or just one that is over a year but all the rest are ok that go over a year?
Are you getting back an negitive #?
I was having problems with minutes over a day and solved my problem by making two datediffs.
If you are gettin a...
lbass,
Thanks for the tip, I tried to concatenate
//{@requestdatetime}:
{wo.requestdate}+{wo.requesttime}
//{@completiondatetime}:
{wo.completiondate}+{wo.completiontime}
but it asked for a number for wo.requesttime and wo.completion time. I tried to put in TimeValues and still nothing.
I then...
Thanks for the "n" I fugured "s" was for seconds, "d" for day but I had no clue what was for minutes, letter "n" sounds good since you can't use "m" do to it's taken for months.
I believe the negitive is because it is based off minutes in a day.
my start time in minutes would be 1389 my ending...
First Thanks for all the help this forum brings! I try to read the archives and have already gained alot of knowlege, but I am still stuck with a problem.
Here is my problem.
I have work orders that are time stamped. Some work orders are created that over flow to the next day. I need to...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.