Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

UK Date not Showing Correctly

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

For some reason it is putting the day in as the month.  How would i get it to go the otherway round?

 

Locale Settings are UK

Need Help

8 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    I think you're going to have to give some sort of details of what you're talking about. What date, where, how...?

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      I up;loaded a pic but for some reason its not showing.  will try again

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        In the calcodes column i have the code

         

        calcodes = DATEVALUE("01"&"/"&[Month of the year]&"/"&[Year])

        For some reason it is putting the month of the year as the day.... any idea?