Map empty/null Date and Time using ValueMapper

odedbadt
odedbadt
in Archive

Hi,

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?

Thanks.

Tagged:

Comments

  • Chronos
    Chronos

    Is anyone able to help out with this request?

  • RGranada
    RGranada Contributor

    Hi,

     

    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 

    MajorDomo@Lusiaves

    **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.

Categories