Now() is returning 1905

Ignition
1

Do to an odd situation that store and forward seemed to have "locked up", I am looking to using the ignition now() function to be saved to the db. Seems pretty straight forward I put the below in an express, but instead of the current date and time I am getting 1905-07-17 00:00:00.000. Any ideas?

dateFormat(now(), "yyyy-MM-dd HH:mm:ss")

2

Where are you seeing this? In the expression editor Binding Preview? Is the clock correct on the PC?

3

Are you secretly (or not so secretly) a time traveller?

1905 is strange as it's prior to unix epoch... Try capital YYYY. Edit: the manual says lower-case

2 Likes
4

Clock is correct. Im not so not sure what you mean Binding Preview Im new. This is just a simple transaction with a triggered expression.

5

Nvm, thanks guys for trying. I accidentally left the type as int, now it works

4 Likes
6

Damn, so not a time traveller :unamused: I thought I was going to provide you the stocks charts and we could have laughed at that Bozos guy's pittance. Next time perhaps

4 Likes
7

On the bright side, once you've gotten your tailfeathers plucked by something like that, it's a lot easier to troubleshoot the next time around.

2 Likes