0

Insert random date for appointment

Hello! 
I wish to insert a random date for a future appoint,enmt. any chacne to implement this?

2 Antworten

null
    • Leonid_Semik
    • vor 4 Jahren
    • Gemeldet - anzeigen

    Hi Badma,

    Sure you can. If you have two date fields "date from" and "date to", then you can use the formula:

    ----
    'random date' := date(random() * (number('date from') - number('date to')) + number('date to'))
    ----

    write the result into the "random date" field

     

    Leo

    • Leonid_Semik
    • vor 4 Jahren
    • Gemeldet - anzeigen

    opps:

    'random date' := date(random() * (number('date to') - number('date from')) + number('date from'))

Anmelden, um zu antworten

Content aside

  • vor 4 JahrenZuletzt aktiv
  • 2Antworten
  • 284Ansichten