Birthday formula?

[RuralGuy]

When you have the form open in design view can you press ^G (ctrl G) and open the immediate window?

[Behedwin]

Okey, i figured out a part of it

This formula works

=Delsträng([PersonnummerTextruta];0;5)

MID seems to be DELSTRÄNG in access and not EXTEXT like in Excel

So above formula works

and it returns what i want.

however, this formula does not work
=År(Delsträng([PersonnummerTextruta];0;5))

[RuralGuy]

Why 0;5 rather than 1;4?

[RuralGuy]

Having any luck?

[Behedwin]

No, i got stuck with other things sadly.

Now back at it.

But im still stuck at not getting formulas to work.
Like i said last

=Delsträng([PersonnummerTextruta];0;5)
It works, it display the 4 first digits from the field PersonnummerTextruta.
It also works to have 1;4

But then i want to extract digits from 4;2 and 6;2 from PersonnummerTextruta
And convert all numbers to a date.

But i can not find a formula that works in Access. In excel it is easy... but access it seems like lots of formulas are missing somehow.

[RuralGuy]

So it looks like Delsträng() is the Mid() string function so now you need to locate the DateValue() function, right?

[Behedwin]

yes that is correct.

Do you got any simple datevalue formula i can use to test?

like i did with delsträng()

[Behedwin]

damn
now Delsträng([PersonnummerTextruta],1,4)
is not working... cant figure it out.
it did work just an hour ago....

also tried Delsträng([PersonnummerTextruta];1;4)

but now nothing works.

this is so weird.

[Behedwin]

starting to give up on this.
access 2016 seems to lack lots of stuff
i dont have any publish tools like this guide tells
https://support.office.com/en-us/art...9-8942b0deab26

all i wanted was to build a simple database with a webform to add and remove data.
have some rather simple commands of presenting the data, like birthdays etc.

[RuralGuy]

Are you using the Immediate window?

[Behedwin]

what is that?

i got o365
installed access and all other software
so i got version 2016 of office.

creating a app in sharepoint.
worked off a template.
it seems however i got way more options if i design a desktop version rather than an sharepoint app.
but there seems not to be any possibility to publish a desktop version to sharepoint.

but when googling around i see only examples of publishing from access 2010

[RuralGuy]

MS Access Immediate Window