A Complicated Date String Conversion

[CharlesWhiteman]

I have the following date/time string

2006-03-08-00.00.00.000000

I need to convert it into

08/03/2006

Any advice most appriciated

 

[boblarson]

How about

DateValue(Left("2006-03-08-00.00.00.000000",10))

 

[boblarson]

Or for a field:

MyDateateValue(Left([FieldNameHere],10))

 

[CharlesWhiteman]

thanks Bob - I worked out that I needed an expression name:

So I've got this

DocDateVal: DateValue(Left([DocumentDate],10))

Now I'm going to hunt down a solution for where there are NULL values

 

[CharlesWhiteman]

I am trying this the following but getting a bit stuck:
DocDateVal: =IIF([DocumentDate] Is Not Null, DateValue(Left([DocumentDate]),10), 0)

 

[CharlesWhiteman]

GOT IT !!

DocDateVal: IIf([DocumentDate] Is Not Null,DateValue(Left([DocumentDate],10)),"")

 

[CharlesWhiteman]

Is there a way to make DateValue display

6 March 2006 instead of 6/3/2006

Thanks

 

[boblarson]

Is there a way to make DateValue display

6 March 2006 instead of 6/3/2006

Thanks

DocDateVal: IIf([DocumentDate] Is Not Null,[COLOR=red]Format([/COLOR]DateValue(Left([DocumentDate],10))[COLOR=red],"d mmmm yyyy")[/COLOR],"")