Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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