Digital Workshop

Hi there,
Tearing my hair out again with Access.
I have a pub that is pulling information from an Access database and displaying on a page,
but the Date/Time information (even though it looks correct in the Access table e.g 10/06/2001) is being displayed 2001-06-10 00:00:00
Does anyone know of a fix???
Really appreciate some advice

Also - there seems to be a problem with moving objects on a page since the update to v 8.02??
I can move objects with the keyboard arrows - but the move tool - although it selects - will not allow me to move???

Regards

Pete

I have emailed DW regarding the object moving with the selection tool problem, but just wanted to ask if others have had any problems since the update??
Pete

The mouse problem has been resolved - it was not an Opus issue.
But if anyone has any ideas how I can resolve the way the date is being displayed (and strip out the time) I would be really grateful.
Thanks
Pete

Hi Pete,
I'm assuming that Access can't give out the required format.
you can reformat the date with a few string functions. I've put a function together that will work on this particular input.
Method::
You use substring(0,10) to extract the first 10 characters in the string, removing the time from the string.
Split the remaining string apart between the "-".
Reassemble by adding the separate elements in the required order along with the forward slashes required.
Drop the script below into a script object and you will see it working.

// example of usage

inString = "2001-06-10 00:00:00";

function strChange(inStr)
{
mySub = inStr.substring(0,10)
arr = mySub.split("-");
newStr = arr[1] +"/" + arr[2] +"/"+ arr[0];
return newStr;
}

outString = strChange(inString);

Debug.trace(outString);

// script end

cheers
Paul

Hi Paul,

Many thanks for your reply.
Quick (are they ever) question
I think I understand your solution - many thanks you are a star as always, - but the string that I want to be reworked is actually a VARIABLE
called <DOD> so would the code be like this:


inString = "<DOD>";

function strChange(inStr)
{
mySub = inStr.substring(0,10)
arr = mySub.split("-");
newStr = arr[1] +"/" + arr[2] +"/"+ arr[0];
return newStr;
}

outString = strChange(inString);

Debug.trace(outString);

No. Anything in speech marks will be treated literally.

Simply pass the function your variable - no speech - no brackets.



Mack

Hi Mack

Sorry - still not quite getting this

Can you tell me what needs to go after

inString = ??????? ;

function strChange(DOD)
{
mySub = inStr.substring(0,10)
arr = mySub.split("-");
newStr = arr[1] +"/" + arr[2] +"/"+ arr[0];
return newStr;
}

outString = strChange(inString);

Debug.trace(outString);


Thanks
Pete

Not quite




*1 You don't need to set the value for inString as per the original example because it's already stored in the DOD variable.

You 'pass' a value to a function by calling the function's name (IE strChange) and including the value (number, string, array or variable) in the brackets after the function name. The actual 'function' as defined by the keyword FUNCTION receives the value into one of its parameters (IE inStr). For example:



The function above accepts three parameters - a, b and c. To use this function we call the function by its name and pass the values we wish to use. EG



In your case, rather than pass a literal value, you pass a variable storing the literal value.



Mack

Hi Mack,

That new code works in terms of displaying the correct date in the debug trace window.
Albeit I had to switch the arr to 2 then 1 and then 0.

SO thank you very much.

However the variable on the page is still showing 1942-10-24 00:00:00

I have this code as a script object on the page
How do I get the new date to show in the DOD variable textbox?

Regards

Pete

Just assign it back to the original variable:



instead of



Mack

Thanks Mack that worked a treat.
I am now looking at your Functions imp (thanks for the correct link) in the hope of being able to ascertain how to populate an array list from an Access Database.

Thanks again
I would like to say I wont bother you again - but I dare say that simply isn't true!!

Warm regards

Pete