set format

[soniasweety]

Hi all,

I have a variable with hard coded  but I want to be dynamic how can set this with the same format

Current Variable:

vToday==num(Timestamp#('08/31/2017 05:00:00','MM/DD/YYYY hh:mm:ss'))

so I need that date should dynamic

[prma7799]

Like this??

vToday=num(Timestamp(Today(),'MM/DD/YYYY hh:mm:ss'))

[its_anandrjs]

Try this

=Num(Timestamp(Today(),'MM/DD/YYYY hh:mm:ss'))

[its_anandrjs]

Use NOW() in place of Today()

Let vToday =Num(Timestamp(Nowy(),'MM/DD/YYYY hh:mm:ss'));

[soniasweety]

not working

[its_anandrjs]

Sorry it is NOW()

Let vToday =Num(Timestamp(Now(),'MM/DD/YYYY hh:mm:ss'));

[soniasweety]

tried that still not working

[prma7799]

Please share some sample file and expected output.

[its_anandrjs]

Ok try this with Floor or not required in the Num format than use timestamp

Let vToday = Floor(Timestamp(Now(),'MM/DD/YYYY hh:mm:ss'));

Let vToday1 = Timestamp(Now(),'MM/DD/YYYY hh:mm:ss');

See Attached