Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Convert dates from Julian to Gregorian (MM/DD/YY format) & sum totals

21 views
Skip to first unread message

aquaflow

unread,
Mar 9, 2009, 12:23:06 PM3/9/09
to
CustNo t1 t2 t3 t4 t_date t_time

35995 0 0 0 300 2008152 4159
35995 0 0 0 303 2008152 4159
35995 20 0 120 226 2008152 8849
35995 0 0 0 0 2008152 9080
35995 1 0 2 5 2008152 9075
35995 0 0 0 0 2008152 9081
35995 0 0 0 232 2008152 8849

These are transactions from transaction log generated by the
application. The t_date is in "julian date" format and i would like to
convert into "MM/DD/YY format" and combine t_date & t_time into one
col.

Also, t1,t2,t3,t4 col are filled in a 24 hr frame so would like these
to be sum per date. How do I do all these in one macro.

Test

unread,
Mar 14, 2009, 10:13:14 AM3/14/09
to
Check this out: http://support.microsoft.com/kb/209922
0 new messages