Load a 5 digit date as mm/dd/yyyy

[#1]

Apologies if this has been asked before but how would I load a 5 digit date ( from an excel sheet ) into QV as mm/dd/yyyy ?

Thanks

[sunny_talwar]

What is the format for you 5 digit date format?

[sunny_talwar]

May be try this:

Date(Date#(YourDateField, 'YourFormat'), 'MM/DD/YYYY') as Date

[stigchel]

You can just use the date function

If your system format is mm/dd/yyyy

Date(ExcelField) as Date

Otherwise

Date(ExcelField,'mm/dd/yyyy') as Date

[#5]

Hi Sid,

You can use

MakeDate(Year(YourDateField ),Month( YourDateField ),Day(YourDateField ))