Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
Having trouble loading my date field in the format as above using the date # function. Any tips on the correct syntax ?
Thanks
Could you post few examples?
So for instance I want to load 2014-05-15 as 05/15/2014 where my date field is called [SALES_DATE]
Load
Date(Date#(YourDate,'YYYY-MM-DD'),'MM/DD/YYYY') as YourDate
From
See attached.