Hello.
I am creating a process control application, but I want to determine the day of the week of the entered date with some kind of trigger.
Do you have any good ideas?
Hello @Akito, welcome to Tulip Community!!
This is certainly possible, using the FORMAT_DATE_TZ() function, and the ‘dddd’ format. You can use the following Expression to extract the day of the week:
format_date_tz(@App Info.Current Date and Time , 'dddd', 'EST')
This is what it looks like in an app:
As you can see here, the day of the week is being stored in a variable on a button click. However, you can also place the logic in the If portion of the trigger to only execute Actions depending on the day of the week.
More information:
-
Expression Editor (search for FORMAT_DATE_TZ()): https://support.tulip.co/en/articles/2864695-technical-details-of-the-expression-editor
-
Moment.JS library for formatting: https://devhints.io/moment
Is this what you’re trying to achieve?? Let me know!!
1 Like
Thank you!
But there is not FORMAT_DATE_TZ() function on my builder.
Do I have to be permitted by TULIP for using this?
Hello @Akito, yes it does have to be enabled - but I believe it should be working for your account. Could you confirm your account URL??
OK, I have enabled it for this account too @Akito.
Can you confirm you’re now seeing the function??
Great!
I could confirm this function and determine the day of week.
Thank you!
1 Like
Hello
May I have the permission to using the FOEMAT_DATE_TZ() function?
Hi @Xin,
FORMAT_DATE_TZ() has been replaced with DATETIMETOTEXT(), which you should have access to use!
DATETIMETOTEXT() function is that I’m looking for
Thanks
1 Like