steveklett
(Steve Klett)
August 12, 2022, 3:22am
1
I need to set a field to the current date in my Import mapping. I added the expression:
{{timestamp "L"}}
which results in the error:
Message: Could not compile handle bar "{{timestamp "L"}}" because "Missing helper: "timestamp"" .Please correct and retry
I also tried the two examples in the handlebar helper page :
{{timestamp HH:MM:SS "America/Los_Angeles"}}
which resulted in the same error:
Message: Could not compile handle bar "{{timestamp HH:MM:SS "America/Los_Angeles"}}" because "Missing helper: "timestamp"" .Please correct and retry
I don't get it, why the error? Am I wrong to thing this helper should be available in the Import mapping context?
As a workaround I used
{{dateFormat "L" timeStamp}}
Hopefully someone can shed some light on this.
umagarimella
(Uma Lakshmi Kanth Garimella)
August 13, 2022, 11:48am
2
Hey Steve,
We have a bug logged for this and we are fixing this in an upcoming release.
You can use `{{{timeStamp "L"}}}`(with a capital S) for now or the dateFormat helper.
steveklett
(Steve Klett)
August 16, 2022, 4:48am
3
Hi @umagarimella ,
My colleague @davidgollom was telling me something about this workaround and I could swear I tried capital Stamp, but still got the error - either way, I just tried it again (per your suggestion) and indeed no error was thrown, BUUUUUUTTtt....... I do get an unexpected result:
{{timeStamp "L"}}
Yields:
2022-08-15T21:44:25-07:00
The Celigo help for the format strings shows "L" as
09/04/2020
When I use workaround:
{{dateFormat "L" timeStamp}}
I get:
08/15/2022
Which is expected. Is this a bug, or do the format strings behave differently in different contexts?
umagarimella
(Uma Lakshmi Kanth Garimella)
August 16, 2022, 5:17am
4
Hey @steveklett
Thank you for reporting this. I'm able to reproduce this. I'll log a bug for this and get it fixed in an upcoming release.
I should have logged something when I found that timestamp vs. timeStamp issue last year. Sorry i was lazy.