Date Conversion

[hawg9]

I have multiple fields where the date is imported as M/D/YYYY. I need to find a way to convert it to YYYYMMDD.

 

[SkipVought]

Hi,

Format([MyDate],'yyyymmdd')

Skip,

_{[red]Be Advised![/red]
The band of elderly oriental musicians, known as Ground Cover, is, in reality...
Asian Jasmine!}

 

[hawg9]

Skip,

I got a validation rule violation and I think it is because this data is imported into a database as a text field. Do you have any suggestions on how I can get around this other than having to have someone re-import the data and change the field types?

Thanks

 

[SkipVought]

Does it matter that you don't REALLY have a date in your table?

Skip,

_{[red]Be Advised![/red]
The band of elderly oriental musicians, known as Ground Cover, is, in reality...
Asian Jasmine!}

 

[hawg9]

No, not if I can get the format to look correct

 

[SkipVought]

So you will NEVER use the "date" to calculate anything, huh?

sLooksLikeDate = Format(DateValue([MyDateString]),'yyyymmdd')

Skip,

_{[red]Be Advised![/red]
The band of elderly oriental musicians, known as Ground Cover, is, in reality...
Asian Jasmine!}

 

[hawg9]

Will this compensate if there are null values as well?

 

[SkipVought]

No, and it won't give you a wake-up call either.

Take a look at NZ

Skip,

_{[red]Be Advised![/red]
The band of elderly oriental musicians, known as Ground Cover, is, in reality...
Asian Jasmine!}

 

[hawg9]

Skip,

in addition, i have set these fields to have a default value now and when I run the first query, it should populate the default values. For some reason, some of the fields are not being populated with the default values that I have defined. Do you have any suggestions?

Thanks -

Chris

 

[SkipVought]

Not only will you not get a wake up call, but my crystal ball is a tad cloudy -- well, REALLY foggy!

I need to see the code that you are referring to.

Skip,

_{[red]Be Advised![/red]
The band of elderly oriental musicians, known as Ground Cover, is, in reality...
Asian Jasmine!}