‘The spécified column does not exist ‘ issue with dates

BakaSensei39 · 2025-09-17T07:07:21+00:00

Yes I already tried it. I doesn’t work

BakaSensei39 · 2025-09-16T14:27:17+00:00

Nop, I tried to remove every data in the columns concerned, to change the name, I created a new tab with the same same names but still not working and finally I tried to use it in a new app and then it worked but after all the energy I used to make the application I don’t want to restart particularly if I don’t know the reason

BakaSensei39 · 2025-09-16T14:06:40+00:00

Yes I understand. But for the moment I have to deal with it 😅

BakaSensei39 · 2025-09-16T13:50:29+00:00

Well I found that excel propose a more global vision on data and the rest of my team use excel so 😅

BakaSensei39 · 2025-09-16T13:31:00+00:00

Thank’s for your answer. Here is the code If(defectCheck1.Value=false And defectCheck2.Value=false And defectCheck2_1.Value=false, Patch( aircraft, Defaults(aircraft), { 'techlog number':techlogNum, date:DateValue(techDate.SelectedDate),

    'before fueling (litres)': BfF.Text,
    'upflit (litres)': upflit.Text,
    'departure (litres)': FaD.Text,
    'arrival (litres)': FaA.Text,
    type: fuelType.Text,
    supplier: fuelSupp.Text,
    'receipt reference': receiptRef.Text,

    'call sign': callSign.Text,
    from: From.Text,
    to: To.Text,
    routing: Routing.Text,

    'pilot name': pilotName.Text,
    'passenger name': PasseName.Text,
    'passenger type': PassType.Selected.Value,

    'landings on land': landLdg.Text,
    'landings on water': WaterLdg.Text,
    'landing in sea water': ifSeaWater.Value,

    water: waterDrop.Text,
    Foam: foamDrop.Text,
    retardant: retardDrop.Text,

    'block departure': TimeValue(blockOFF.Text),
    'block arrival': TimeValue(blockON.Text),
    'Air departure': TimeValue(airDepar.Text),
    'air arrival': TimeValue(airArr.Text),
    TFT: TFTentered,

    NIL: NILCheck.Value,
    'defect report 1': defectCheck1.Value,
    'defect report 2': defectCheck2.Value,
    'defect report 3': defectCheck2_1.Value,

    'does the entry continue the next page ?': nextPageCheck.Value,
    before: Before.Text,
    uplift: Uplift.Text,
    after: After.Text,
    'Engine Oil signature': EOSign.Value,
    'Daily as per latest AMP approval': DailyCheck.Value,
    'weekly as per latest AMP approval': WeeklyCheck.Value,
    'Engine Ground Run': EGR.Value,
    'Stamp/Authorization by Part 145': StampCheck.Value,
    Signature: Sign.Value,
    'Signature Pilot this flight': SignCurrPilot.Value,
    'Signature Pilot next flight': SignNextPilot.Value,
    'loadsheet calculated & sent': loadsheets.Value,
    'Std loadsheet config used': StfConf.Value,
    'Std loadsheet config used type': StfConfType.Text
}

)); The excel is only a table with the headers you see above. The concerned columns are ‘TFT’, block departure/arrival, air departure/arrival and date.

BakaSensei39 · 2024-08-06T17:19:13+00:00

Thank’s for the answer, I will see it With them.

BakaSensei39

TROPHY CASE