date decimal back to date

[ken gray]

is there a way to get the decimal (1-366) value of the date and then convert it back to a date in different formats?

Code:

Copy      Help

_s.time("%j")

[Gintaras]

What formats?

[ken gray]

well, it's really more of a yak shaving function.
i have a directory of files that have a 6 digit YYMMDD*x*.??? name format and i want to create a dialog that'll ask for a "start" and "end" date of the files to pull. So, i thought if i took the dates, from the user input, and got the decimal numbers of each date, then took all the numbers between (and including) and converted them back to dates in YYMMDD format and fed them into a dictionary i could compare it to the array i built with the "YYMMDD" portion of the file name and pull only the files that have the dates in the filenames i need.

make any sense?

[Gintaras]

If you'll get only 1-366, how you'll know YY?

[ken gray]

good question. i can pull that from the user input and do some hoop-jumping based on how the numbers look.

if from date =277 then 1-276 equals the next year.

there may actually be "no chance" that they could pull over 12 months of data (files), so i won't have to make the multi-year logic.

[Gintaras]

This example converts day 100 to YYMMDD string and uses current year for YY part.

Code:

Copy      Help

int i=100

DATE d=_s.time("%Y.01.01") ;;beginning of this year
d=d+i
;out d
str s
s.time(d "yyMMdd")
out s

[ken gray]

thanks.

im getting this error though

Error (RT) in Macro2: 0x80020005, Type mismatch.

[Gintaras]

Maybe "%Y.01.01" is not recognized in your locale. Try "01/01/%Y".

[ken gray]

crazy americans and their date formats!

"01/01/%Y"


thanks!!

[TheVig]

DELETED...didn't read post above clearly enough!!

[TheVig]

I got the from date to day of the year with this:

Code:

Copy      Help

DATE d="01/24/08"

str s
s.time(d "%j")
out s

Now to just get back...I'll work on it.

[QM Assistant]

Function DateFun

Code:

Copy      Help

int i=100

DATE d=_s.time("01/01/%Y") ;;beginning of this year
d=d+i
;out d
str s
s.time(d "MMddyy")
out s

[TheVig]

I had to subtract 1 from the i...but it works!

Code:

Copy      Help

DATE d="02/28/07"

str s
s.time(d "%j")
out s

int i=val(s)

DATE d2=_s.time("01/01/%Y") ;;beginning of this year
i-1
d2=d2+i

str s2
s2.time(d2 "MM/dd/yy")
out s2