calculating date of conception

[waelk38411626]

Hello everyone, 

I need help please.

I have three fields 

the first ist the lenthe of the embryo (LCC)

the seconde is the gestationnel age (Terme LCC)

the thrird is the date of conception (DG LCC)

when I choose the lenthe (LCC) of 10,2 mm that gives me (Terme LCC)  7 weeks 

i need to calculate the date befor 7 weeks 

every time i change the lenthe the Terme LCC changes 

help please

[waelk38411626]

I wanted to add that the count from current date 

[Nesa Nurani · Accepted solution]

So whatever number is in "Terme LCC" that many weeks should calculate?

If yes to above, use this as 'Validation' script of "Terme LCC" field and change "dd-mmm-yyyy" to whichever date format you want:

var date = new Date();
if(event.value == "")
this.getField("DG LCC").value = "";
else {
var str = event.value;
var n = str.match(/\d/g);
var num = n.join("");
date.setDate(date.getDate() -num*7);
this.getField("DG LCC").value = util.printd("dd-mmm-yyyy", date);}

[waelk38411626]

thank you very much.

I'm gratfull for you

it works but I made a mistake

how can I count days also

and how can substract 2 weeks from the resultat   

exemple  the age is 6 weeks + 1 days => date of conception is  25 / 01 / 2022 (from current date)

thanks alot

[Nesa Nurani]

Substract 2 weeks and show that date in "DG LCC"?

6 weeks 1 day, where do you enter those values, please be more specific?

[waelk38411626]

Un thé same field "DG LCC"

thank you 

[waelk38411626]

Weeks + days please 

[Nesa Nurani]

If you enter "7 SA" (like in your photo) actual date is 5 weeks +1day?

[waelk38411626]

IF I enter "7 SA +  0 day" Date of conception "DG LCC" is befor 5 weeks + 0 day

if I enter "7 SA +  1 day" Date of conception "DG LCC" is befor 5 weeks + 1 day

if I enter "7 SA +  2 day" Date of conception "DG LCC" is befor 5 weeks 2 1 day

itc ...

thanks

[waelk38411626]

sory for the last :

if I enter "7 SA +  2 day" Date of conception "DG LCC" is befor 5 weeks + 2 day

[Nesa Nurani · Accepted solution]

Try this:

var date = new Date();
if(event.value == "")
this.getField("DG LCC").value = "";
else {
var str = event.value;
var n = str.match(/\d/g);
var nw = n.join("");
var num = nw.slice(0, -1);
var numday = str.match(/(\d+)(?!.*\d)/g);
date.setDate(date.getDate() -(Number(num)*7-14+Number(numday)));
this.getField("DG LCC").value = util.printd("dd-mmm-yyyy", date);}

[waelk38411626]

Thanks alot 

you are genius.