Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
What is the format for you 5 digit date format?
May be try this:
Date(Date#(YourDateField, 'YourFormat'), 'MM/DD/YYYY') as Date
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
Hi Sid,
You can use
MakeDate(Year(YourDateField ),Month( YourDateField ),Day(YourDateField ))