Sign in to Community
Sign in to view all badges
Expand my Community achievements bar.
don't use July 1, 2013 but 1/7/2013
then it's just about using the DATAVALUE() function to transform text into dates. The function can only deal with dd/mm/yyyy dates.
Same with ReportBuilder!!
Flagging as a duplicate of Change Date Format to something that can be recognised by Excel - show your support by upvoting there!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.