Hi, I develop a Django project with internationalization English/French
dates have to be displayed with the dd/mm/yyyy format when user webbrowser is FR and yyyy-mm-dd when user webbrowser is EN to do that, I use JS that test webbrowser user favorite language and display format accordingly That works fine until I change my model to add *unique_together* constraint with this date Now, I got the error when webbrowser is in french and I try to register date (*asp_ent_dat*) date format "20/03/2020" is invalid. Correct format is "yyy-mm-dd". > > Reading Django documentation about validation, I 'understand' that *unique_together* is the model validation that seems to fail because of date format I try adding DATE_INPUT_FORMATS = ['%Y-%m-%d', '%d-%m-%Y', ] in settings.py, the second format corresponding to the french format I need, but it does'nt works *I can I fix my problem:* *Have unique_together constraint on 3 fields including asp_ent_dat and display date in french format in my form?* *models.py:* class Entree(models.Model): asp_ent_cle = models.AutoField(primary_key=True) asp_ent_loc = models.CharField("Site concerned by the operation", max_length=10, null=True, blank=True) med_num = models.CharField("Trial batch number", max_length=3, null=True, blank=True,) asp_ent_dat = models.DateField("Entry date", null=True, blank=True) asp_ent_pro_pay = models.CharField("Country of treatment origin in case of entry", max_length=10, null=True, blank=True) asp_ent_pro_sit = models.CharField("Processing source site in case of entry", max_length=10, null=True, blank=True) opr_nom = models.CharField("Input operator", max_length=10, null=True, blank=True) opr_dat = models.DateField("Entry date", null=True, blank=True) log = HistoricalRecords() class Meta: db_table = 'pha_asp_ent' verbose_name_plural = 'Entries' ordering = ['asp_ent_cle'] unique_together = ['asp_ent_loc','med_num','asp_ent_dat'] *JS:* $(function(){ if(window.navigator.language == 'fr-FR' | window.navigator.language == 'fr'){ $("#id_asp_ent_dat").datepicker( { dateFormat: 'dd/mm/yy', } ); } else { $("#id_asp_ent_dat").datepicker( { dateFormat: 'yy-mm-dd', } );}); -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/393c0328-3148-466b-b9e4-eb6111fdaff6%40googlegroups.com.