Convert string into date 2

[Ann28]

Hi

The date is a in a string format '200301'
How do I convert it into valid date format?

Thanks a lot

 

[vidru]

Assuming that your format is YYYYMM, this will return the first date of that month/year:

Date(Int(200401/100), 200401 Mod 100, 1)

-dave

 

[vidru]

Whoops, missed the "string" part...

Date(Int(val({Table.Field})/100), Val({Table.Field) Mod 100, 1)

-dave

 

[synapsevampire]

Interesting approach, Dave, a star for creativity.

I would have used the brute force:

cDate("01/"+mid("200301",5)+"/"+left("200301",4))

-k

 

[vidru]

Thanks k,

I'm all too familiar with that YYYYMM format (we use it for Billing Periods).

-dave

 

[synapsevampire]

I'd guess that the brute force method is faster since it doesn't do as much, but yours was clever, if not artistic.

-k