Map empty/null Date and Time using ValueMapper


I would like to map empty values of Date and Time to another value (for example, current date and time) using ValueMapper.

Is there a way to do so?




  • Is anyone able to help out with this request?

  • RGranada
    RGranada Contributor



    I don't think value mapper has the ability to use inline function only static values for replacing.


    Anyhow you can achieve that later (If it suites you)  in a Beast Mode or a MySql DataFlow with the following:


    IFNULL(your_date_field, CurDate())


    Hope this helps. 

    Ricardo Granada 


    **If the post solves your problem, mark it by clicking on "Accept as Solution"
    **You can say "Thank you" by clicking the thumbs up in the post that helped you.