Skip to content

Instantly share code, notes, and snippets.

View pierreprinetti's full-sized avatar

Pierre Prinetti pierreprinetti

62 followers · 71 following
View GitHub Profile
@pierreprinetti
pierreprinetti / cf2dn
Created July 21, 2014 09:55
Formula Microsoft Access per estrarre la data di nascita dal Codice Fiscale (formato gg/mm/aaaa)
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)
@pierreprinetti
pierreprinetti / Go.sublime-build
Created March 7, 2014 15:20 — forked from Machx/Go.sublime-build
{
"cmd": ["/usr/local/go/bin/go","build","$file"],
"selector" : "source.go",
"variants": [
{ "cmd": ["/usr/local/go/bin/go", "run", "$file"],
"name": "Run"
}
]
}