Universe Design Question (regarding Crystal Functions)

[gonzo27]

Hello,

I need to know the Universe Designer syntax for the following 2 Crystal Functions that I created to translate Mumps Date and Mumps Time.


Function (StringVar MTIME)
TimeSerial(0,0,tonumber(MTIME))

This takes a numeric and translates it to a time...for example "70" gets translated to 12:01:10 AM (the MTIME keeps the seconds since midnight)


Function (StringVar MDATE)
DateAdd("d", +tonumber(MDATE), #Jan 01, 1841#)

This takes the numeric value and assigns a date since the MDATE is a count of the days that have gone by since 1/1/1841

I do not know the Oracle Syntax so please point me in the right direction...

Thank you,
G

 

[blom0344]

Oracle allows you to simply add integers to a date like:

sysdate + 1  = 'tomorrow'

So the startdate combined with the mdate should yield the proper date

For time this may just be a bit more complicated.

Look into the 'Mod' function for breaking down the integer to a time like format..

Ties Blom

 

[gonzo27]

Thank you so much...

I'm not sure if I didn't explain it correctly but the MDATE field keeps a number representing the days that have gone by since 1/1/1841....so won't me adding this number to sysdate give me a future number? or am I supposed to use MDATE (it's a number though) in place of sysdate, I don't know why they called it "MDATE" when it stores a number not a date..

Appreciate the help!
J

 

[blom0344]

It was just an example. Adding the integer value to 1/1/1841 (as date) should yield the proper date..

Ties Blom