Forum Discussion

MJG2112's avatar
MJG2112
Icon for Advocate II rankAdvocate II
5 months ago
Solved

Date to Text Format Differences - Causing Me a Big Problem

I have a set of reports that create composite keys using a numeric value and date.  It's very basic but serves my needs.   CompositeKey = MyTable[EntityID] & "-" & MyTable[Reporting Month]   Th...
Need Help
Show and Tell
  • MJG2112's avatar
    MJG2112
    5 months ago

    hi mizan2390 that worked with the addition of a locale parameter at the end of the FORMAT:

     

    CompositeKey = MyTable[EntityID] & "-" & FORMAT(MyTable[Reporting Month], "dd/MM/yyyy", "en-GB")

     

MJG2112's avatar
MJG2112
Icon for Advocate II rankAdvocate II
5 months ago

hi mizan2390 that worked with the addition of a locale parameter at the end of the FORMAT:

 

CompositeKey = MyTable[EntityID] & "-" & FORMAT(MyTable[Reporting Month], "dd/MM/yyyy", "en-GB")

 

mizan2390's avatar
mizan2390
Icon for Super User rankSuper User
5 months ago

MJG2112 , great to know that it helped you to reach to a solution.