date function informations

[#1]

hi,

I' ve a little question about the date function, the problem is the following:

I need a function to do this:

2012001 must become= 1/1/2012

2012002 must become= 2/1/2012

....

2012032 must become= 1/2/2012

...

thank you very much

[jonathandienst · Accepted solution]

Hi

Assuming you want this in script (let's call your input dates InputDate):

     ...

     Date(MakeDate(Left(InputDate, 4), 1, 1) + Mid(InputDate, 5, 9)) As OutputDate,

     ...

You can use the same logic in an expression, but this sort of transform should be done in script)

Hope that helps

Jonathan