Creation Date Definition

[mosa.gh...@gmail.com]

Hello Support ,

I have a report which is retrieve the data from collection, I already defined the column in the report to display creation date as a Text , but I have
a problem that when I implement a filter on the creation date , I haven't the between choice, I have just (contain , does not contain , =,!=) choices ,and when I define the creation date column as date, then the data disappear from column.

Kindly Find Attached.

Please Advise.

Regards,
Mousa Gharaibeh

[Sabine El Rassy]

Hello Mousa,

How is your creation date stored? If its a measure make sure that you choose Date in the type of your measure within the process as well.

Regards,

Sabine EL RASSY

PreSales Consultant

Contact: selr...@runmyprocess.com

Website: Fujitsu RunMyProcess

3 Rue de Gramont 

75002 Paris - France

Mobile   : +33 (0) 6 22 10 64 61

     

Fujitsu RunMyProcess user? Please add a review on GoogleApps Marketplace

Afin de contribuer au respect de l'environnement, merci de n'imprimer ce message qu'en cas de nécessité.

Be environmentally friendly: do not print this email unless it is entirely necessary.

--
Fujitsu - RunMyProcess
---
You received this message because you are subscribed to the Google Groups "RunMyProcess Support Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to supportforum...@runmyprocess.com.
To post to this group, send email to suppor...@runmyprocess.com.
Visit this group at http://groups.google.com/a/runmyprocess.com/group/supportforum/.
To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/de7548c4-56df-49cc-89d5-4124fe93abd5%40runmyprocess.com.
For more options, visit https://groups.google.com/a/runmyprocess.com/groups/opt_out.

[mosa gharaibeh]

Hi Sabine ,

it's defined on start event as an input variable , then I saved it in the collection.(this report reflect the collection data).Kindly find the below 

Creation Date =

<#setting time_zone="UTC">

<#setting datetime_format="MM/dd/yyyy HH:mm:ss">

<#assign utc=now("MM/dd/yyyy HH:mm:ss")?datetime>

<#setting time_zone="Asia/Calcutta">

<#-- your utc time has been transformed to IST local time-->${utc}

Regards,

Mousa Gharaibeh

You received this message because you are subscribed to a topic in the Google Groups "RunMyProcess Support Forum" group.
To unsubscribe from this topic, visit https://groups.google.com/a/runmyprocess.com/d/topic/supportforum/ZTqrFBJqsLI/unsubscribe.
To unsubscribe from this group and all its topics, send an email to supportforum...@runmyprocess.com.

To post to this group, send email to suppor...@runmyprocess.com.
Visit this group at http://groups.google.com/a/runmyprocess.com/group/supportforum/.

To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/CAHWwz%3DpucTxSdtQrd0bR_AnAoqux5i-Zdzw9gGwHBn4%3DjGrMHw%40mail.gmail.com.

For more options, visit https://groups.google.com/a/runmyprocess.com/groups/opt_out.

--

 

 

 

 

Regrads,

Mousa Gharaibeh

[Sabine El Rassy]

Hello Mousa,

If you're using a collection report, and trying to display a Date column, you need to save your creationData variable in your collection as a number (representing the number of seconds) and not as a string. So you have to check if the format of your creationDate within your collection (go to the following url https://live.runmyprocess.com/live/${P_customer}/object/${your_collection_name}  )

Regards,

[mosa gharaibeh]

Hi Sabine,

it's means that I can just save it as a number , in order to make the between choice appear. then how the creation date appear in the report? as a number?

Please Advise.

Regards,

Mousa Gharaibeh

--

Fujitsu - RunMyProcess
---
You received this message because you are subscribed to a topic in the Google Groups "RunMyProcess Support Forum" group.
To unsubscribe from this topic, visit https://groups.google.com/a/runmyprocess.com/d/topic/supportforum/ZTqrFBJqsLI/unsubscribe.
To unsubscribe from this group and all its topics, send an email to supportforum...@runmyprocess.com.
To post to this group, send email to suppor...@runmyprocess.com.
Visit this group at http://groups.google.com/a/runmyprocess.com/group/supportforum/.

To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/CAHWwz%3DoJsVyQe0SyDtY410FLtercV_TKVF-cddBE_esQG6shyw%40mail.gmail.com.

For more options, visit https://groups.google.com/a/runmyprocess.com/groups/opt_out.

--

 

 

 

 

Regrads,

Mousa Gharaibeh

[Sabine El Rassy]

Mousa,

When you save the date in seconds as a number, you can choose within your collection report Date as Type of your column. It will be automatically converted to the corresponding date shown as a string within your report.

Regards

Sabine

[mosa gharaibeh]

Hi Sabine ,

Thanks a lot for your support ,but in any format it will be displayed? , I need to define it as the below form MM/dd/yyyy HH:MM:SS . How Can I implement this format?

Regards,

Mousa Gharaibeh

--

Fujitsu - RunMyProcess
---
You received this message because you are subscribed to a topic in the Google Groups "RunMyProcess Support Forum" group.
To unsubscribe from this topic, visit https://groups.google.com/a/runmyprocess.com/d/topic/supportforum/ZTqrFBJqsLI/unsubscribe.
To unsubscribe from this group and all its topics, send an email to supportforum...@runmyprocess.com.
To post to this group, send email to suppor...@runmyprocess.com.
Visit this group at http://groups.google.com/a/runmyprocess.com/group/supportforum/.

To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/CAHWwz%3DosoOH2S-A-DeZuTWO4me7EyVCf8AKUSc7i6nKBcjWZOQ%40mail.gmail.com.

For more options, visit https://groups.google.com/a/runmyprocess.com/groups/opt_out.

--

 

 

 

 

Regrads,

Mousa Gharaibeh

[Sabine El Rassy]

It will be automatically converted to this format MM/dd/yyyy HH:MM:SS. All you need to do is to save it as seconds.

Sabine EL RASSY

PreSales Consultant

Contact: selr...@runmyprocess.com

Website: Fujitsu RunMyProcess

3 Rue de Gramont 

75002 Paris - France

Mobile   : +33 (0) 6 22 10 64 61

     

Fujitsu RunMyProcess user? Please add a review on GoogleApps Marketplace

Afin de contribuer au respect de l'environnement, merci de n'imprimer ce message qu'en cas de nécessité.

Be environmentally friendly: do not print this email unless it is entirely necessary.

You received this message because you are subscribed to the Google Groups "RunMyProcess Support Forum" group.

To unsubscribe from this group and stop receiving emails from it, send an email to supportforum...@runmyprocess.com.

To post to this group, send email to suppor...@runmyprocess.com.
Visit this group at http://groups.google.com/a/runmyprocess.com/group/supportforum/.

To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/CAL-%3Dn-xUOD3t%2BPtJqQ8x-hKh5TzjurgE8WMrihPEq2LRixuRcA%40mail.gmail.com.

[madhuri.ru...@gmail.com]

Hi,

when you are saving the date record in collection from web interface might be the date field in web interface was in TEXT format.
So if you will choose this date as numeric variable then it will save the record in collection as date. Then the date will be visible in report as date and you will get conditions like(=,<=,>=,>,< etc..)

Thanks,
support team