Time

Avatar

08-05-2008

Hello, how would I be able to make a text field show the current time (est) automatically? Thanks!!

Replies

Avatar

Avatar
Boost 500
Level 10
pguerett
Level 10

Likes

612 likes

Total Posts

7,689 posts

Correct reply

692 solutions
Top badges earned
Boost 500
Boost 50
Boost 5
Boost 3
Boost 250
View profile

Avatar
Boost 500
Level 10
pguerett
Level 10

Likes

612 likes

Total Posts

7,689 posts

Correct reply

692 solutions
Top badges earned
Boost 500
Boost 50
Boost 5
Boost 3
Boost 250
View profile
pguerett
Level 10

08-05-2008

You can add this FormCalc command to your Initialize event for the field that is supposed to hold the Time:



$=Num2Time(Time())



This will give you the current time in the format the your system uses.

Avatar

03-02-2009

I have a Decimal field on the form. This form is bound to a XML element where the value looks like this: 1,234.00.

When form is getting printed I have to show this value in the currency format: $1,234.00.

I tried to use Display option from "Patterns" to pick "$1,234.00", but it didn't work. I tried ALL currency formatting and still didn't work. If I replace "," in the XML for the value to look like this 1234.00, it works. But, is there any way to do it without replacing ","?

Can someone, please, give me a hint what am I doing wrong?

Thank you.