KEY TABLE - problem

[adiarnon]

hi,

i created a kay table.

one of the fields in this table is date

when im creating a list box of the date field i see duplications:

like-

1/1/12

1/1/12

1/1/12

2/1/12

3/1/12

3/1/12

...

can someone halp me to understand why?

i need that each value will be shown once...

[jonathandienst · Accepted solution]

Hi

This is most likely because those dates contain a time portion which is hidden by the format. Test this by using Num(date) in a list box - you will see a fractional part which is the time.

Load with the Floor() function to get a clean date or use Date(Floor(date)) in the list box.

HTH

Jonathan

[MayilVahanan]

Hi

Try like this'

Load Date(floor(Datefield)) As Datefield  ...

Hope it helps