Skip to content

Instantly share code, notes, and snippets.

@pierreprinetti

pierreprinetti/cf2dn

Created July 21, 2014 09:55
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save pierreprinetti/fe0a936d3f89594e2cd2 to your computer and use it in GitHub Desktop.
Save pierreprinetti/fe0a936d3f89594e2cd2 to your computer and use it in GitHub Desktop.
Download ZIP
Formula Microsoft Access per estrarre la data di nascita dal Codice Fiscale (formato gg/mm/aaaa)
Raw
cf2dn
dn: iif(IIf(Mid([CodFiscale];10;2)>40;Mid([CodFiscale];10;2)-40;Mid([CodFiscale];10;2))<10;"0"& IIf(Mid([CodFiscale];10;2)>40;Mid([CodFiscale];10;2)-40;CInt(Mid([CodFiscale];10;2)));IIf(Mid([CodFiscale];10;2)>40;Mid([CodFiscale];10;2)-40;Mid([CodFiscale];10;2))) & "/" & Switch(Mid([CodFiscale];9;1)="A";"01";Mid([CodFiscale];9;1)="B";"02";Mid([CodFiscale];9;1)="C";"03";Mid([CodFiscale];9;1)="D";"04";Mid([CodFiscale];9;1)="E";"05";Mid([CodFiscale];9;1)="H";"06";Mid([CodFiscale];9;1)="L";"07";Mid([CodFiscale];9;1)="M";"08";Mid([CodFiscale];9;1)="P";"09";Mid([CodFiscale];9;1)="R";"10";Mid([CodFiscale];9;1)="S";"11";Mid([CodFiscale];9;1)="T";"12") & IIf(Mid([CodFiscale];7;2)<15;"20";"19") & "/" & Mid([CodFiscale];7;2)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment