Digital Workshop

Hi,
can someone help me?
i would to format a date taken from a access database to a format
ex: Day Month Year
because now he take me
1989-09-12 00:00:00

and i would
12-09-1989 or 12-settembre-89

if is possible set it to italian ?
thanks

up

I've looked over your request several times. There is no EASY solution. You first must extract the data from the data base and place it into a variable (or preferable multiple variables) in OPUS. If you can break the pieces into separate variables during the "READ" portion of the project, that would be helpful, otherwise you will need Scripting to read the numeric data and create separate variables for the year, day, and month.

OPUS has Select and Case under Actions -> Programming. You would insert your month variable in the Select statement, then create a Case for each month. For example, when the Case is equal to "1" you would give another variable a value of "Jan" or "January" or whatever it would be in Italian. You have to create all 12 possible months, plus I'd have something in case there is no month data, or if the value is greater than 12.

Use a Frame with an "On Show" Trigger to read the data base, break apart all the data into separate variables, then assign alpha characters to a numeric value. Finally, you take each of the number variables and alpha characters and place them within a Text Object in the format you desire.

...but can you make an axample for this?
so, how i can separate the data, on the database the format of the data is
13/12/1958

how can i separate this on 3 variables?

thanks

Use this:


//CREATE AN ARRAY CONTAINING MONTH STRINGS
myCal = new Array('Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sept','Oct','Nov','Dec')



//EXAMPLE OF USE
accessDate = "2008-10-30-00-00-00"
Debug.trace(formatDate(accessDate))
//END OF EXAMPLE



//FUNCTION THAT EXTRACTS SUBSTRINGS FROM PASSED DATE AND CONVERTS MONTH TO STRING

function formatDate(x)
{
return x.substring(8,10)+'-'+ myCal[parseInt(x.substring(5,7)-1)] +'-'+ x.substring(0,4)


if you are pulling data in via opus actions, wrap the variables in the function else you can simply call the function in your scripts.

The English can be changed to whatever language you like.

Mack

can you upload an example maked with opus please?

Paste Mack's script into a script object and hit F5 to see it working.

Paul

see attached example, I'm using the split function.

but how i can delete this final numbers? (in red)
1989-09-12 00:00:00

Use split twice -- the first time to split on the spaces " "
Then split the first part (firstSplit[0]) using "-"

// script #################################

foo = "1989-09-12 00:00:00"

firstSplit = foo.split(" ");
secondSplit = firstSplit[0].split("-");

v1 = secondSplit[0];
v2 = secondSplit[1];
v3 = secondSplit[2];

// ####################################

Explanation::
The first split will separate the date string at the first space, leaving "1989-09-12" in the array element firstSplit[0].
You can ignore the rest of the array as it contains the unwanted part "00:00:00".
Now split the array element "firstSplit[0]" into a second array using "-" to make the final separation into the three variables required.

Paul

that's all right,
now it's possible to create a imput mask for date?
example

21/08/1980

__/__/____

It would be easy if Opus had Regular Expressions.
Unless you can guarantee that the date is always entered exactly in the format DD/MM/YYYY it won't be easy.
The easiest way around the problem would be to use three input boxes and limit the length of input accordingly.

Paul

well, thanks

RegExp would be a great addition to Opus Script!

Mack

ok but how i can store onto database the 3 imput of relative day,mounth,year?