You are viewing limited content. For full access, please sign in.

Question

Question

Token for numeric value of date

Workflow Laserfiche Cloud
Updated November 9, 2022
asked on November 9, 2022

Hello,

In Excel if I use DATEVALUE i can get numeric value for a date, how can I create a Token for the same in Workflow?

 

Excel if I use: =DATEVALUE("09/15/2022") it gives me 44819

I need this Token....

 

Many Thanks,

S

0 0

Replies

replied on November 9, 2022

Excel seems to behave as documented.

Can you explain what you are trying to do? The value in your example is already a date, so it wouldn't need conversion through the DATEVALUE function in Workflow.

0 0
replied on November 9, 2022

I have a process in which i have a number field which is mapped to date, this number is then saved to DB & later in other process it's checking with this if the data exists.

 

It works fine when there is only 1 date, however in another process I have more than one date & that's why I need to convert these dates to number value...

 

 

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...