Date Format

Does anyone know a way to format Lawson query builder date format mm/dd/yyyy to LawsonTXN node date format yyyymmdd? I have tried all the JS functions with no success.

Thank you!

Shaji

Find more posts tagged with

Process Automation (IPA) - General Discussions

Comments

robert-canham

you have to do a two-step process on it. you can use the pfDate(var1, 'mm/dd/yyyy') function to turn your LawsonTXN date into a date object, then you can use getDateAGS(var1) to turn that into yyyymmdd (I'm pretty sure that's the format of the getDateAGS function).

unknown

Yep, rmcanham is correct. Here's an example:

Input variable: inDateDME_str = "03/06/2016"

jscript: outDateAGS_str = getDateAGS(pfDate(inDateDME_str,'mm/dd/yyyy'))

Result: outDateAGS_str = 20160306

I hope this helps. Good Luck!

Kelly

unknown

That may have done it guys. Thank you! I will test and update.

unknown

I like using this one...

format.formatDate(today(),'yyyyMMdd')

Must be capitol MM or it will pull minutes values instead of months.

Copyright © 2025 Infor. All rights reserved.