Date Transforms

[Guest]

Morning to all,

Could someone supply me a way of transforming a numerical (6 digit) number
into a date

The format is held 251006 (dd/mm/yy)

I need it in date format so I can calculate with it correctly

Thanks in advance

Jason

 

[Van T. Dinh]

If it is a numeric Field as you wrote:

DateSerial([Value] MOD 100, ([Value] MOD 10000) \ 100, [Value] \ 10000)

If it is a String value (that looks like number)

DateSerial( Right([Value], 2), Mid([Value], 3, 2), Left([Value], 2) )

 

[Guest]

Once again hat's off to you

Worked a treat

Thanks again

If it is a numeric Field as you wrote:

DateSerial([Value] MOD 100, ([Value] MOD 10000) \ 100, [Value] \ 10000)

If it is a String value (that looks like number)

DateSerial( Right([Value], 2), Mid([Value], 3, 2), Left([Value], 2) )

--
HTH
Van T. Dinh
MVP (Access)

Morning to all,

Could someone supply me a way of transforming a numerical (6 digit) number
into a date

The format is held 251006 (dd/mm/yy)

I need it in date format so I can calculate with it correctly

Thanks in advance

Jason