none
Set Account Expiry for contractors RRS feed

  • Question

  • Dear All,

    I am trying to set EmployeeEndDate by using following query. but the problem is time. 

    DateTimeAdd(DateTimeNow(),"180.00:00:00.0"). 

    its adding current time in the employeeEndDate. want to add fixed time

    Thanks in Advance,

    Shashidhar Joliholi

    Friday, November 22, 2019 7:27 AM

Answers

  • Hi,

    Well...., you're adding to DateTimeNow(), and that's the current date and time.

    If you want to add to e.g. EmployeeEndDate, you need to do:

    DateTimeAdd([//Target/EmployeeEndDate],"180.00:00:00.0")

    Br,

    Leo


    Did my post help? Please use "Mark as answer" or "Propose as answer". Thank you!

    • Marked as answer by Shashidhar J Monday, December 9, 2019 4:46 AM
    Monday, November 25, 2019 8:06 AM

All replies

  • Hi,

    Well...., you're adding to DateTimeNow(), and that's the current date and time.

    If you want to add to e.g. EmployeeEndDate, you need to do:

    DateTimeAdd([//Target/EmployeeEndDate],"180.00:00:00.0")

    Br,

    Leo


    Did my post help? Please use "Mark as answer" or "Propose as answer". Thank you!

    • Marked as answer by Shashidhar J Monday, December 9, 2019 4:46 AM
    Monday, November 25, 2019 8:06 AM
  • Thanks for the reply,

    Its working...!

    Thank you,

    Shashidhar

    Monday, December 9, 2019 4:47 AM